ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Discontinuous conditional formats (https://www.excelbanter.com/excel-discussion-misc-queries/250609-discontinuous-conditional-formats.html)

Barb Reinhardt

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


Luke M

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