Excel: Shade alternate rows

I always think that shading alternating rows makes wide spreadsheets much easier to read. Here is a quick & easy way to shade every other row.

  1. Highlight the range of cells that you want to format
  2. Choose Format from the pull-down menu
  3. Select Conditional Formatting to display the Conditional Formatting dialog box
  4. Select Formula Is from the first drop-down list box, and enter =MOD(ROW(),2)=0 in the second box
  5. Click the Format button to bring up the Format Cells dialog box
  6. Select the Patterns tab and specify a color for the shaded rows. Choose a light color so the black text will still be legible
  7. Click OK twice to return to your worksheet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s