Forum Discussion
Conditional Formatting duplicating rules
Hi! I recently encountered a very big problem with Conditional Formatting in Excel 2013. Now, I don't know if this is fixed in later versions of Excel. I can not upgrade my version either, at...
- Yes that happens a lot with CF rules. What I tend to do is have a stashed-away row which has just the CF rules and formatting set up exactly right. To fix things I copy that row and paste-special, formats it on top of all "working" rows.
Yes that happens a lot with CF rules. What I tend to do is have a stashed-away row which has just the CF rules and formatting set up exactly right. To fix things I copy that row and paste-special, formats it on top of all "working" rows.
Okay, seems like a good way around it.
Does this remove the leftover rule though, or is that still there?
Does this remove the leftover rule though, or is that still there?
- It should replace all rules in the area.
Will need to try this properly on monday, if it works it should also make for a fairly simple VBA script, which would be great to minimize work. Thank you!