How to Highlight Two Rows With Two Columns of Duplicate Values

[JSteph]

I need to know how to highlight two rows who each have duplicate values in
two specific columns? Thanks

 

[Max]

I need to know how to highlight two rows who each have duplicate values in
two specific columns?

Perhaps a sample to illustrate would be best:
http://www.freefilehosting.net/download/NDkxNDk=
CF to highlight col values found in another col.xls

Note: Do not click direct on the link if you're reading this from MS'
webpage. Do a copy n paste of the entire link, inclusive of the trailing "=",
into your browser address bar.

Assume the values to be compared are in cols A and B

Select col A (A1 active)
Apply CF using Formula Is:
=ISNUMBER(MATCH(A1,B:B,0))
Format > light brown fill > Ok out
This will CF' fill values in col A found in col B (light brown)

Select col B (B1 active)
Apply CF using Formula Is:
=ISNUMBER(MATCH(B1,A:A,0))
Format > blue fill > Ok out
This will CF' fill values in col B found in col A (blue)


---