Question

How to compare two columns in excel using vlookup with example?

Answer 1

Select the cells you want to highlight (you can select cells within one columnor in several columns if you want to highlight entire rows). Click Conditional formatting > New Rule… > Use a formula to determine which cells to format.