https://www.myonlinetraininghub.com/excel-find-and-remove-duplicates Highlight Duplicates with Conditional Formatting Conditional Formatting can quickly highlight duplicates in a column. Simply select the column of cells containing the suspected duplicates > Home tab > Conditional Formatting > Highlight Cells Rules > Duplicate Values: Tip: You can change the format by clicking the drop down for ‘Values with’ (see image above). Once the formatting is applied you can use filters (Data tab > Filters), based on the cell fill color or font color to display or hide the duplicate values: Pros: Great for visually highlighting duplicates in a column while retaining them in the dataset. You can use filters to hide duplicates or focus on them. Cons: Duplicates remain in the dataset, and that may be exactly what you want, but if you just want to get rid of them, then keep reading. This method also doesn’t highlight the row and only identifies duplicates