Duplicate a conditional formatting rule is now possible with the version of Excel 365.
New only for Excel 365
The advantage of working with Excel 365 is that updates arrive faster and periodically (about every 6 months).
Since the end of 2021, a long-awaited novelty has been added; Duplicate a conditional formatting rule.
This saves a lot of time for creating custom conditional formatting rules.
Previous version of conditional formatting management.
Previously, the conditional formatting rules management menu had only three options
- New rule
- Edit Rule
- Delete Rule
New duplicate rule button
But now, a fourth button has been added to the Rules Manager dialog box.
And when you click on it, the selected rule is duplicated 😀👍