Countif is simpler compared to a lookup formula. Also Read: Find Duplicate Entries in Two Columns with Excel Formula It can be done with a Lookup or Countif Formula. Also we cannot select only the duplicate entries. The problem with this method, is that it highlights all the differences with same colour. No, Excel will compare the data in selected data range and highlight all the duplicate entries. Values with repetition will be highlighted. Choose the font colour & background to highlight.Choose “Conditional Formatting” -> “Highlight Cells Rules” -> “Duplicate Values”.Just to see the duplicate entries with colour difference follow this method. Are you not excited to get such a easy solution? Read more Compare & Highlight Matching Duplicate Records Assume the data to compare are in Columns A & B. This methods can be used to compare huge column of data within less time. Out of these three methods, the third one is very faster. The first is in a column called “Scheduled,” and the other in a column called “Registered.” We’re going to highlight the names in the second column that don’t match those in the first. On this sheet, you’ll see two lists of names. Comparing two lists in Excel is an easy task using a conditional formatting expression and color to visually identify the differences.
