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.
Select Paste Values, or if you are using Ctrl+V, click the Paste Options button, and select the Values icon, and Excel won't copy any formatting to the destination.
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.