Have you ever had a long list of items and you need to quickly identify which ones are duplicates? Thankfully, Excel’s Conditional Formatting feature makes it easy to quickly find duplicates in Excel.
Open your Excel file and highlight the data that may have duplicates.
From the ribbon, select Home (tab), Styles (group), Conditional Formatting (icon), Highlight Cells Rules (menu), Duplicate Values…
Optional: From the second drop down choose a format for highlighting duplicate values, then click OK.
The duplicates should now appear in the format you chose.
We hope you have found this trick useful. In a future blog post we will discuss how to use another Excel feature to easily remove duplicates from a list.