Apply alternate row shading that updates automatically (2000/2002/2003)

by Kara Soos

Application:

Microsoft Excel 2000/2002/2003

Operating System:

Microsoft Windows

Worksheets often span hundreds or thousands of rows, which can wreak havoc on your eyes. Alternate row shading makes it easier to read large data tables, but if you manually shade rows, any changes you make to the data later will cause problems with your shading.

Here’s a quick way to apply row shading to every other row in your data using conditional formatting. Just follow these steps:

1. Select the data range to which you want to apply alternate row shading.

2. Choose Format | Conditional Formatting from the menu bar to open the Conditional Formatting window.

3. Select Formula Is from the dropdown list.

4