how do I use conditional formatting for alternating cell shading?

[Exceluser]

I need to alternate cell shading based on the row number(even, odd). I need
to know how to do this using the MOD with the Row function as argument. I am
using Excel in Office XP version 2002.

Thanks

 

[Gos-C]

Hi Exceluser,

See http://www.andrewsexceltips.com/menu_formats_colour_set_rows.htm

Gos-C

 

[Ron Coderre]

Here you go:

http://cpearson.com/excel/banding.htm

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[Biff]

Hi!

If you want to shade the odd rows:

=MOD(ROW(),2)=1

If you want to shade the even rows:

=MOD(ROW(),2)=0

Biff