CF is good.

If the data is on separate worksheets, you will need to create defined names
for the ranges and use these.

So, assuming the named range for Sheet 2 is s2Keys, the formula to match
would be like

=ISNUMBER(MATCH(A2,s2Keys,0))

and format the cells.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"LC in Boston" wrote in message
...
Am trying to figure the most efficient way to compare two spreadsheets
that
will have customer/account information -- trying to ID duplicate names
between the two sheets. Looked on Help and am still not sure if
conditional
formatting is the way to go?