Computer Tips

Shading Alternate Rows in Excel

Finding it hard to follow a row across the page in your Excel spreadsheet?  Thinking what happened to that striped computer paper we used to run reports on?  Well now you can have those stripes in your spreadsheet thanks to Excel's conditional formatting feature.  This will make thing easier to find on screen or on paper.

How To:

  1. Highlight the range of cells that you want to format.
  2. From the drop down menu select Format -> Conditional Formatting this will bring up the the Conditional Formatting dialog box.


     
  3. From the first drop down option in the Conditional Formatting dialog box select Formula is, then in the second box type in the formula =MOD(ROW(),2)=0 in the second box.
  4. From the Conditional Formatting dialog box click on the Format button to bring up the Format Cells dialog box.
  5. By clicking on the patterns tab you can now select a color for the background of the alternate rows. Make sure you choose a  light color which will allow you to see the content of the cells. You can do any other formatting you would like which is available here such as font, font type, color etc.



    As you can see we get a preview of what the shaded row will look like and can adjust the formatting until we like the results.
  6. Now that we are happy with our selections we simply click OK to accept the formatting options your spreadsheet now has every other row highlited.

The great part about this is that the formatting stays in every other row wether you delete a row, insert a row etc.

Before:
After: