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.
This would also work, although we would need to paste formulas instead of values. I believe we have tried this and that the formatting rules didn't quite like it for some reason.
There's another option in the Paste Options menu that will copy the formulas as well, without the formatting. it's the third option if you right click, and in the full paste special menu, there is a formulas and number formatting option that should work for your purposes.