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".
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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