When a conditional formatting rule is overkill, use these VBA procedures to highlight duplicates and then remove the highlighting in Microsoft Excel.

If you want duplicate values to stand out in an Excel spreadsheet, you can choose between two conditional formatting rules.

The Highlight Function in Excel. Regardless of whether your Excel spreadsheet contains a little or a lot of data, you may want to have cells that meet certain criteria stand out. Excel lets you ...