Duplicate rules

Duplication can be used, for example, when you need to create several rules of the same type for different ranges. In this case, it is more convenient to create a single rule and then duplicate it, adjusting the range of application in the duplicates.

To duplicate a rule, follow these steps:

1. Open the Conditional formatting pane.
2. Hover your cursor over a rule in the list.
3. Click  More and select Duplicate.

The duplicate will appear in the list below the original rule.