See http://www.xldynamic.com/source/xld.CF.html#rows

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Kjetil" wrote in
message ...

I have a worksheet with 10.000 rows, and I would like to colorize every
other
"group" of rows. A bit hard to explain, but here is an example:
1 <-- Gray
1 <-- Gray
1 <-- Gray
2 <-- White
2 <-- white
4 <-- Gray
4 <-- Gray
4 <-- Gray

Does anybody have a good idea on how to do this automatically?


--
Kjetil
------------------------------------------------------------------------
Kjetil's Profile:
http://www.excelforum.com/member.php...o&userid=29362
View this thread: http://www.excelforum.com/showthread...hreadid=490729