I get it now.
Final shot <vbg
=MOD(ROW(1:1)-1,7)<3
--
HTH
Bob Phillips
"Luc Benninger" wrote in message
...
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
|