How to shade groups of 5 rows using conditional formatting

[avidcat]

I want to shade groups of 5 rows.

Basically shade 5 rows, 5 rows not shaded..

I have experience doing every other row, but not grouping 5 rows at a time.

Thanks or any help.

Nick

 

[Joe4]

Try this:

=ISEVEN(INT((ROW()-1)/5))

 

[avidcat]

Perfect Thanks!

 

[Joe4]

You are welcome!