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.

Click Conditional Formatting > Manage Rules. Select the icon set you just created and click the Edit button. Here, you can set how to display the icons based on the value of the cell.