Monthly Archives: September 2006

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