Alternate Shaded RowsWhen I have an Excel spreadsheet with several rows of data, sometimes it’s nice to shade alternate rows. This is easier on the eyes when reading through several rows. You can buy third party software that will do this for you at the click of a button, but it’s very simple to apply this formatting without it. Here’s how it’s done:

Select the area that you would like to alternately shade. If you want to do the entire spreadsheet, click on the top left corner, above Row #1 and to the left of Column A.

  1. Go to the Home tab of the ribbon.
  2. Click on Conditional Formatting under Styles.
  3. Select New Rule.
  4. Under Select a Rule Type, choose: “Use a formula to determine which cells to format.”
  5. Under “format values where this formula is true”, enter: =MOD (ROW(),2)=0
  6. Click the Format button
  7. Click on the Fill tab.
  8. Select the color desired, click ok, then ok one more time.The result will be alternating shaded rows.
Top