View Single Post
  #9   Report Post  
Luc Benninger
 
Posts: n/a
Default

Then I run into trouble if someone deletes the first row. the
conditional format formula will have a ref error and no formatting at
all will be applied.

Bob Phillips wrote:
Then how about =MOD(ROW(A1)-1,7)<3