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 ...

Avoid frustration and unintended formatting by learning how Excel applies conditional formatting rules.

Explore and use preset rules for conditional formatting Thanks to Microsoft’s preset rules, you don’t necessarily need to create a custom rule from scratch.

Formulaic conditional formatting rules in Microsoft Excel can be tricky, so learn how to avoid a common mistake.