Alternate Background-colors

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.

Originally Posted by sissi

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