Uncategorized
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.
![](https://futuretechtrends.co.uk/wp-content/uploads/2022/05/Black-White-Penguin-Design-Brand-Identity-for-Clothing-Fashion-Logo-200-×-40-px-600-×-40-px-600-×-75-px.png)
When a conditional formatting rule is overkill, use these VBA procedures to highlight duplicates and then remove the highlighting in Microsoft Excel.