Discontinuous conditional formats

[Barb Reinhardt]

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

 

[Luke M]

The easiest way for conditional formatting (and data validation) to get
messed up is when somebody copies info from somewhere else and paste's into
the form. While they see this as a convenient way to move data, the default
"paste all" setting will destory any preset formatting you have. Not everyone
does a "paste w/o formatting" or simply "paste values only".

 

[מיכ×ל (מיקי) ×בידן]

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