Alternate Background-colors

  • Thread starter Thread starter sissi
  • Start date Start date
S

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 gree
background, the next 150 rows blue background again and so on.

How can i do that autmatically?

Cheers
Siss
 
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 forma
green.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Banding groups 5
Change cell background color based on content that results from li 4
conditional format - table - cell empty return default color 1
Alternate Row Coloring 6
Background stays when sorting 2
Copy Conditional Formatting? 1
Change background color based on value in column A 4
Excel automatic background color 1

Back
Top