![]() |
Discontinuous conditional formats
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 |
Discontinuous conditional formats
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 |
Discontinuous conditional formats
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 |
All times are GMT +1. The time now is 03:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com