You found me. Now go away. I like this stuff, unless I say otherwise. My hobby is hobbies. I keep adding more. I'm not done. Nuerburgring (live webcam)
www.flickr.com
Mar
10th
Tue
permalink

Alternate Row Shading In Excel

This is a simple one, but a good one.

1. Select the range that you want to format
2. Choose Format, Conditional Formatting
3. In the Conditional Formatting dialog box, select Formula Is from the drop-down list, and enter this formula:

=MOD(ROW(),2)=0

4. Click the Format button, select the Patterns tab, and specify a color for the shaded rows.
5. Click OK twice to return to your worksheet.

Credit: spreadsheetpage.com