Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi-
I have tried multiple times, and I am losing the order of conditional formatting for a cell when I copy it to another cell. The relative reference copies well, and things work if correct the order of the copied rules. I found references on other discussions forums that this is a bug in Excel, but, I didn't find any reference to it in this forum or on Microsoft's official site, so it a bug ? or another "feature" ? Is there any way around it ? And, yes, I need the order because I have four rules, and up to three of them can be correct in the same time. And, no, I can't merge the rules because the provided interface is so flexible.... While I am at it, when copy/pasting rules keep on piling up. I wish there was a flag to override rules, instead of keep on merging them in a random order.... This feature is nice and new, but, it is not well implemented... Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting - How do I delete ALL rules? | Excel Discussion (Misc queries) | |||
conditional formatting - order of rules | Excel Discussion (Misc queries) | |||
Paste conditional formatting rules | Excel Discussion (Misc queries) | |||
More than 3 rules of conditional formatting | Excel Discussion (Misc queries) | |||
I need 5 conditional formatting rules-excel only allows 3 | Excel Discussion (Misc queries) |