Why not simply have the conditional format refer to the same cell (or a cell
in the same row) as the cell containing the conditional format? Provided
that you exclude "$" symbols ie ensure that the cells within the conditional
format are all expressed as relative, then the conditional format function
should still work if you copy the cell (or just copy special the formats)
down. Then any row that is deleted should not give rise to any error
message, and the row colouring should be preserved.

Thus, in cell A1, use =MOD(ROW(A1)-1,7)<3
but in cell A2, use =MOD(ROW(A2)-1,7)<3
etc

--
Return email address is not as DEEP as it appears
"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