Identifying duplicate data using conditional formatting One of the easiest ways to locate duplicate data in Excel is to use conditional formatting. Here's how.