Compare two columns, highlight matches

[privatemoon]

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

 

[Caribeiro77]

Try this your sheet:

Book1
	A	B
1
2	abc@gmail.com	yst@gmail.com
3	ghs@gmail.com	yur@gmail.com
4	yag@gmail.com	abc@gmail.com
5	yur@gmail.com	tri@gmail.com
6
7
8	TRUE
Sheet1

Cell Formulas
Range	Formula
A8	=A2=B4

 

[privatemoon]

I see 'FALSE' on my sheet. Weird.

 

[Caribeiro77]

Check if the contents of that cells are both:

abc@gmail.com

 

[privatemoon]

Just checked, they are indeed the same, I just copied the values from your sheet and pasted the values into a new sheet. So in theory, they should've been the same.

EDIT: Nevermind, I found the issue. It was because all the values started from A1, rather than A2.

EDIT2: The issue that was fixed was the 'TRUE' part, I still can't get the highlighted cells.