Try conditional formatting with a formula of

=ISNUMBER(MATCH(A1,Sheet2!A:A,0)

and

=ISNUMBER(MATCH(A1,Sheet1!A:A,0)

--
HTH

Bob

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

"Funky" wrote in message
...
Hello

I have two set of data. I have to match that both contain PCO12345.
All PCO# # # # are different. Majority are in both files but some of
the them are missing. There is no particular order. Is there any way
to find PCO # # # # that are in both files and which ones are
missing? I there any easy method like if statements? other than going
through each finding each PCOnumber one by one. There are 2300+
recods.

thanks in advance