Microsoft Excel: How to Alternate The Color Between Rows

Sometimes you need to make large spreadsheets easier to read. Alternating colors between rows is a good way to do it. Here's how:

Start by selecting the cells you want to apply color banding to. Or press [Ctrl][A] to select the entire sheet.

A drop-down menu will display, click New Rule.

A drop-down menu will display, click New Rule.

The New Formatting Rule dialog appears. Click the bottom option labeled Use a Formula to Determine Which Cells to Format.

In the empty format value field, copy and paste in the following formula: =MOD(ROW()/2,1)>0

The New Formatting Rule window will look like this. Click Format.

Pick a fill color and click OK.

The New Formatting Rule windows will display the color Preview. Click OK.

The section of your spreadsheet will now be color banded.

If you want to change the color or add more cells, highlight the cells on the spreadsheet. Then on the Ribbon go to Conditional Formatting > Manage Rules.

The Conditional Formatting Rules Manager window comes up. Click Edit Rule.

You'll be taken back to the Edit Formatting Screen and can adjust accordingly.

This Tech Tip is brought to you by the Business and Technology Section ... IT solutions for today's CPAs. For more information and to view an archive of previous Tech Tips, please visit us here.

Do you have specific topics you would like to see covered in Tech Tips? Email any suggestions to