EXCEL: How to compare two columns and highlight common values

A frequently asked question is how to compare two columns in Excel and highlight common values. Today we show you how to do it in Excel with Match and Conditional Formatting.

[billnard]

Years later, this video still helps out! Thank you.

[bcdchannel]

hell yeah after a lot of videos, i found yours and functionally work perfect! 1 subcribe button from me

[HelpBeHappy]

Very simple and easy explanation in short time

[dineshkrishnasai]

Thanks a lot friend it cool...it reduced lot of human work

[julianrogan]

My issue is column A has unique values, column B contains matches with column one and duplicates that only appear in column 2. I used this formula: =MATCH(A2, $B$2:$B$10237, 0). What I got was all of column B was matched and some of the positive matches were not matched in column A

[Helena-kqtr]

This was very helpful, thank you! However, I'm finding that this returns any cell with a partial piece of the information that is duplicated, for example, Thomas Jones will be matched to Jason Thomas or Thomas Matthews. Any suggestions on how to work around this?

[jamietan]

what if you want to highlight both columns with the common names? what is the formula you use?