Highlight Duplicate Data in Microsoft Excel
To highlight duplicate values, click Home > Conditional Formating > Highlight cells rules > Duplicate Values
Start Learning Start Exploring
To highlight duplicate values, click Home > Conditional Formating > Highlight cells rules > Duplicate Values