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.