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 abc@gmail.com <-highlight ghs@gmail.com yag@gmail.com yur@gmail.com <-highlight Col B yst@gmail.com yur@gmail.com abc@gmail.com tri@gmail.com

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

This thread is current as of April 04, 2015.

For more resources for Microsoft Excel