How to Highlight Every Other Row in Excel

Step-by-Step Guide

1. 1

   Step 1: Launch Microsoft Excel.

   In Excel 2003, this is found in the Format menu.
   
   In Excel 2007 and 2010, this is found on the Home tab in the Styles section. , In Excel 2003, set condition 1 to "Formula is." In Excel 2007 and 2010, click "New Rule" and then choose "Use a Formula" as the rule type to highlight rows.
   
   Enter "=MOD(ROW(),2)=1" in the formula box, without the quotation marks. , Choose the desired fill color and pattern and then click the OK button to apply the rule. ,
2. 2

   Step 2: Choose the "Open File" command

3. 3

   Step 3: browse to the file you'll be working with and click the OK button to open the file.

4. 4

   Step 4: Select the rows that you will be highlighting by clicking and dragging to select the entire range of cells.

5. 5

   Step 5: Apply the Conditional Formatting feature.

6. 6

   Step 6: Create a new formatting rule using a formula to determine which cells to format.

7. 7

   Step 7: Click the Format button to apply the highlighting color and shade.

8. 8

   Step 8: Review the conditional formatting and make any necessary changes to the fill color and pattern for better legibility.

Detailed Guide

About the Author