Question: how to find common between two columns in excel?
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.