I'm Kevin. I work in IT. I'm a car fiddling, mountain biking, home brewing, music playing kind of guy. I'll be posting things that interest me. If you like something you read tell me at movekevin at gmail dot com. 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