Highlighting Rows by Criteria
Hi, Try putting this formula into the conditional formatting of all the cells
of the range you want highlighted:
First select "Formula Is"
=OR(MOD(ROW(),6)=1,MOD(ROW(),6)=2,MOD(ROW(),6)=3)
Then set your formatting.
Regards - Dave.
|