how do I use conditional formatting for alternating cell shading?

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

Here you go:

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

Does that help?

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

XL2002, WinXP-Pro


"Exceluser" wrote:

> 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

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

"Exceluser" <[email protected]> wrote in message
news:[email protected]...
>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