Highlighting duplicated values in 2 lists using conditional formatting.

[INN]

Hi
I have 2 lists. I want to compare list 1 with list 2 and if the name in list1 appears in list2 then I want to highlight that name in list1 in red for example but not doing anything to the same name in list2. So I highlighted List1 and then went to Conditional Formatting and wrote this formula

=COUNTIF($B:$B,A1)>1

But it did not work. I also want to do the same thing for List2. Compare names in list2 to names in list1 and if the name appears in List1 then highlight the name in list2 in green for example. Any idea how can I do that. Thank you very much.

List1	List2
Linda	Mike
Adam	Liz
Anna	Tao
Bob	Jack
Tao	Jim
Liz

 

[Peter_SSs]

There may possibly be an issue with exactly what you had selected when you applied that CF, but the last part of your formula should be

=COUNTIF($B:$B,A1)>0

Here is another approach that you could use

23 06 20.xlsm
	A	B
1	List1	List2
2	Linda	Mike
3	Adam	Liz
4	Anna	Tao
5	Bob	Jack
6	Tao	Jim
7	Liz
8
9
10
Dupes

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:B10	Expression	=MATCH(B2,A:A,0)	text	NO
A2:A10	Expression	=MATCH(A2,B:B,0)	text	NO

 

[INN]

Yes, the >0 made the difference and the Match function amazingly worked very well as well. Thank you so much for your help. I appreciate the help

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.