Help with comparingtTwo Lists

[nesre]

Hello

i need help to compare two columns with another two columns and highlight differences

for example, if i have table

John 6 John 6
Maria 2 Maria 2
Mike 2 Mike 2
Mike 1 Mike 4
Mike 5 Mike 6

i want formula, which will compare first 2 columns, with 3,4 columns and highlights matched records, in my example only first 3 rows

Thanks

[sunflowers]

Try to use conditional formatting with formula as below :

=($A1=$C1)*($B1=$D1)

See attachment file for your example

[nesre]

sunflowers

Thank you very much

[nesre]

hi again, can anyone help me

now i want formula which, will compare and highlight first 2 columns with another two columns, but highlights same entries in any rows. for example:

John 6 John 5
Mike 1 Mike 3
Mike 2 Mike 1

i want highlight second row in 1 and 2 column and third row in 3 and 4 column

Thanks

[JeteMc]

This solution uses two conditional formatting rules. The rule for A1:B3 is:

Please Login or Register  to view this content.

The rule for C1:D3 is:

Please Login or Register  to view this content.

Let me know if you have any questions.

[nesre]

JeteMc

great solution

thank you very much

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to mark the thread 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.