Most valuable professional
  • Hot Topics

Excel Compare two columns, highlight matches

Is there a way to compare two columns and highlight all the items in column A that can be found in column B? For example: Col A [email protected] <-highlight [email protected] [email protected] [email protected] <-highlight Col B [email protected] [email protected] [email protected] [email protected]

This question generated 24 answers. To proceed to the answers, click here.

This thread is current as of April 4, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel