highlight duplicated values

[INN]

Hi I have 2 lists A and B, if a value in list B has a duplicated value in list A then I want to highlight that value either in A or B to different color. But this duplicated value in list B can have also duplicated value in the same column that I do not want to highlight. In the example below, I want to highlight 2 in List A because in list be i have 2. Is that possible? Thank you so much.

A	B
1​	10​
2​	2​
3​	2​
4​	40​
5​	50​

 

[Joe4]

Select column A, then go to Conditional Formatting, select New Rule,. then "Use a formula to determine which cells to format" and enter this formula:

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

Then choose your desired formatting style and color and click "OK".

 

[INN]

Thank you. That works. Thanks a lot.

 

[Joe4]

You are welcome.

 

[shinigamilight]

Control select both the columns then go to conditional formatting and highlight duplicate values.