1
Microsoft Excel 2013: Compare two Lists in Excel and Highlight Matches
Comparison of lists of data is something that we do all the time. This tutorial gives details
that you can apply immediately to compare lists using Excel 2013 to find Duplicate or
Unique data.
Of course, you need at least two lists of data. Just to make it simpler and easier to read,
let’s name the two lists as 1st and 2nd Lists of Customers as shown below.
Select both columns of data that you want to compare. On the Home tab, in the Styles
grouping, under the Conditional Formatting drop down choose Highlight Cells Rules,
then Duplicate Values.
On the Duplicate Values dialog box select the colors you want and click OK. Notice
Unique is also a choice.
2
Even before you click OK take notice it is already showing you the duplicates!
Once you click OK, then click into an empty cell anywhere on your sheet, then you will
see the duplicates highlighted as shown below.
To remove the rule, click on Conditional Formatting, Clear Rules, Clear Rules from
Entire Sheet.
