How to Highlight Duplicates in Excel?

Paul Bryant03 Aug, 2022Finance

One of the most popular ways to identify duplicate data is to highlight them. Highlighting also happens to be the easiest of the three approaches to finding duplicates in Excel and it provides a visual aspect other duplication identification methods lack. Here are some simple steps: 1. Select the cell range in which you want to highlight duplicates 2. Ensure you?re in the Home tab (on the upper left), then select the Conditional Formatting dropdown 3. Opt for Highlight Cells Rules and click on Duplicate Values