Follow the steps below to set up alternating row colors in Excel:
- Highlight the rows that you wish to apply the formatting to. You can also select the entire sheet.
- Under the Format menu, select Conditional Formatting.
- When the Conditional Formatting window appears, select “Formula Is†in the drop down list.
- Enter the following formula:
=mod(row(),2)=1 - To select the color you want to see in the alternating rows, click on the Format button.
- In the Format Cells window, select the Patterns tab. Then select the color you want to use and click OK.
- Click OK again to close the Conditional Formatting window.