To copy the contents and the formatting, choose All merging conditional formats. To combine your copied formats with existing conditional formats in the paste area, click the Merge Conditional ...

Office Q&A: How to stop Excel’s paste task from overwriting destination cell’s format Your email has been sent It's not easy to fool Excel, but with a few extra clicks, you can work around ...