How to Compare 2 Columns in Excel?

To compare 2 columns in Excel, you need the VLOOKUP function and a conditional formatting rule

Excel,Microsoft,Compare 2 columns,VLOOKUP,Condtional formatting,Excel tricks,