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

how do I use conditional formatting for alternating cell shading?
 

Hi Exceluser,

See http://www.andrewsexceltips.com/menu...r_set_rows.htm

Gos-C


--
Gos-C


------------------------------------------------------------------------
Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
View this thread: http://www.excelforum.com/showthread...hreadid=511432

how do I use conditional formatting for alternating cell shading?
 

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

how do I use conditional formatting for alternating cell shading?
 

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" wrote in message
...
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