How to shade groups of rows in excel.

[Alberto Martinez]

I have data that is captured daily for 6 different ids. I wish to highlight/shade each group of six rows in a different color. I know using 'mod(row(),2) will do the trick for every other row, but the idea is to have 6 rows in one color and the next six in the other and so on.


I hope this makes sense. Thank you in advance!

 

[Claus Busch]

Hi Alberto,

Am Thu, 17 Apr 2014 08:05:03 -0700 (PDT) schrieb Alberto Martinez:

I have data that is captured daily for 6 different ids. I wish to highlight/shade each group of six rows in a different color. I know using 'mod(row(),2) will do the trick for every other row, but the idea is to have 6 rows in one color and the next six in the other and so on.

select your Range from A1 on => CF => Formula:
=ISEVEN(INT((ROW()-1)/6))


Regards
Claus B.