Highlighting duplicate pairs across columns

[Zorbadog]

Hi All

I have two columns of data and would like to highlight those values that are duplicated across both columns as in the example below.

Untitled.png

If it is easier to highlight unique pairs (the white ones) instead that would be ok too.

many thanks

[PaulM100]

Apply this CF rule: =OR(AND($A3=$A2,$B3=$B2),AND($A3=$A4,$B3=$B4))

[Zorbadog]

Hi PaulM100

Many thanks. I have tried this but it only seems to highlight the bottom two rows.

[Zorbadog]

The 'remove duplicates' function is exactly what i need, I just need them highlighted instead of removed! Or a number ie 1 added to another column so I can filter.

[kvsrinivasamurthy]

Conditional formatting is used.
Select A3:B8
Home --> Conditional formatting --> NNew Rule
Use a formula to determine which cells to format
Paste the below formula
Format for the color
OK-->OK

=COUNTIFS($A$3:$A$8,$A3,$B$3:$B$8,$B3)>1

[Zorbadog]

Conditional formatting is used.
Select A3:B8
Home --> Conditional formatting --> NNew Rule
Use a formula to determine which cells to format
Paste the below formula
Format for the color
OK-->OK

=COUNTIFS($A$3:$A$8,$A3,$B$3:$B$8,$B3)>1

Thank you very much but not sure it is still quite right. If I try it on the attached it does not give the correct results. The 24 XXX's and the 14 yyy's should highlight.

Book1.xlsx

regards

[kvsrinivasamurthy]

=COUNTIFS($A$1:$A$10,$A3,$B$1:$B$10,$B1)>1

Formula applied is not correct for A1:B10

Corrected formula is here

=COUNTIFS($A$1:$A$10,$A1,$B$1:$B$10,$B1)>1

[Zorbadog]

=COUNTIFS($A$1:$A$10,$A3,$B$1:$B$10,$B1)>1

Formula applied is not correct for A1:B10

Corrected formula is here

=COUNTIFS($A$1:$A$10,$A1,$B$1:$B$10,$B1)>1

That work perfectly. Thank you very much.

[kvsrinivasamurthy]

Welcome. Thanks foe feedback and rep.