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