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.
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!
