From where I sit it is not easy to answer that question.
However, If you add a row between(!) rows that has CF on them - then the CF
will be Inherited to the new row, as well.
If you add a NEW row at the bottom(!) of that range - the CF will not go
along.
The workaround is to declare that range as a LIST [TABLE in "2007"].
Using a table will inherit the CF no matter where you add the row.
Micky


"Barb Reinhardt" wrote:

I'm cleaning up a workbook that has a lot of conditional formats. Let's say
they were all originally applied to cells A2:A420. Now it's A2:A10,
A100:A420 ... as an example. What would cause this change? Inserting rows
or what? I'd like to mitigate this "fix" effort from ever having to be done
again.

Thanks,

Barb Reinhardt