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.

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

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.

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