View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default 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.