How to use VBA to highlight duplicate values in an Excel spreadsheet

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

source https://www.techrepublic.com/article/how-to-use-vba-to-highlight-duplicate-values-in-an-excel-spreadsheet/#ftag=RSS56d97e7