About this tutorial:
Video duration: 3:10
Visit this page to download the sample file for this video. The example is on the DupRules sheet in the sample workbook.
In Excel, you can use the conditional formatting to highlight one or more cells, based on rules.
In this example, the conditional formatting rules are duplicated automatically, when rows are inserted or deleted in the table.
This can cause a huge mess of rules in the workbook, with many duplicates. Your workbook could slow down in some cases.
See how to remove the duplicates quickly, and get back to just the…