This video explains how to highlight duplicates that appear between two columns. A combination of VLOOKUP and conditional formatting is used to achieve the result.

This video tutorial will explain how to:
Highlight duplicates across multiple columns
Compare to columns in Excel
Compare two lists to highlight matched records or differences
------------------------