Conditional Formatting Between Two Ranges

[arthurz11]

1st range A1:B2 (sometimes values are duplicated)
2nd range A5:B6 (sometimes values are duplicated)

If any values in range A1:B2 matches values from A5:B6 they are highlighted. The data changes in range A5:B6.

 

[Joe4]

First select range A1:B2 and enter this Conditional Formatting formula and choose your desired color.

=COUNTIF($A$5:$B$6,A1)>0

Then select ranges A5:B6 and enter this Conditional Formatting formula and choose your desired color.

=COUNTIF($A$1:$B$2,A5)>0

Sample result:

 

[arthurz11]

First select range A1:B2 and enter this Conditional Formatting formula and choose your desired color.

=COUNTIF($A$5:$B$6,A1)>0

Then select ranges A5:B6 and enter this Conditional Formatting formula and choose your desired color.

=COUNTIF($A$1:$B$2,A5)>0

Sample result:
View attachment 116522

Thank you. It works great!!!

 

[Joe4]

You are welcome!
Glad I was able to help.