Hi

I have a really big excel sheet with more than 20000 rows.

I would like to set the background color alternate every 150 rows.
means: the first 150 rows blue background, the next 150 rows green
background, the next 150 rows blue background again and so on.

How can i do that autmatically?

Cheers
Sissi


--
sissi
------------------------------------------------------------------------
sissi's Profile: http://www.excelforum.com/member.php...o&userid=37820
View this thread: http://www.excelforum.com/showthread...hreadid=573781