How to Highlight Two Rows With Two Columns of Duplicate Values
 

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

How to Highlight Two Rows With Two Columns of Duplicate Values
 

"JSteph" wrote:
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)

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---