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

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.

Conditional formatting works by applying rules to the data in your spreadsheet. The rules won't work as intended if your data is disorganized, inconsistent, or poorly structured.

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