Use conditional formatting and place these formulas in the
first condition =MOD((ROW()-MOD(ROW(),150))/150,2)=0 and format blue
second condition =MOD((ROW()-MOD(ROW(),150))/150,2)<0 and format
green.
sissi Wrote:
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
--
Excelenator
------------------------------------------------------------------------
Excelenator's Profile:
http://www.excelforum.com/member.php...o&userid=36768
View this thread:
http://www.excelforum.com/showthread...hreadid=573781