Forum Discussion

Copper Contributor

Dec 16, 2016

Conditional formatting - keep formatting

Hallo. I have the following issue. I have to compare the values of two worksheets. All differences will be highlighted with a special background color. That works without any issues. But, in the end...

excel

Wyn Hopkins

MVP

Dec 16, 2016

HI Lutz Gebhardt

There's no built in way to do this.

I found this article on using VBA to do it

http://excel.tips.net/T001947_Removing_Conditional_Formats_but_Not_the_Effects.html

I also saw a suggestion to copy the data into Word and then back into Excel, which on the face of it appears to work (if it's just values) but not sure how practical that is, or if there are other consequences.