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

"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
---