Question: how to find matching values between 2 excel columns?
Answer: Highlight column A by clicking the column header. ...  Select the Conditional Formatting button under the Home tab. ...  Select New Rule from the Conditional Formatting drop-down list. ...  Select the 'Use a formula to determine which cells to format' option. ...  Enter the formula provided in the text box.