View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kjetil
 
Posts: n/a
Default Coloring rows in excel


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