Hi,

Select colmn B data and then

Format|Conditional format - Formula is

and use this formula

=COUNTIF(A:A,B1)=0

Pick a colour (say) Red
Ok
Any numbers in col B and Not in Col A will be highlighted red.

Mike

"Patti Backman" wrote:

Hello,
I have two columns of data. The first (column A) is a master part list that
has no typos, the second (column B) is a part list of parts stored at my off
site storage facility. These part #'s are typed in manualy and sometimes
contain typos that mean we can not find the parts when we need them. How do
I ask the question: Are there any part numbers in column B that do not match
a part number in column A? This would highlight a typo for us.
Thank you in advance.