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.