Don't stop, there's always the gem that you spot that would then be missed.

Anyway, it helps show the OP that there is more than one way, and that way
they should learn more.

Best Regards

Bob


"Duke Carey" wrote in message
...
Bob -

You know - I gotta stop putting my $.02 in, because you and other MVPs
keep
offering up suggestions & solutions that put mine to shame.


"Bob Phillips" wrote:

Greg,

Try

=NOT(ISNUMBER(MATCH($C4,Supply,0)))

you can also simplify yours to

=ISNUMBER(MATCH($C4,Supply,0))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"GregR" wrote in message
ups.com...
I have a worksheet that has many columns, one of which is a model
number. I have conditional formated this column, so that if the model
number exists in a table(Supply) on another sheet, it colors the cell.
I am using the following formula in CF to get that result:

=$C4=vlookup($C4,Supply,1,False) and it works as designed. What I want
is the opposite effect, if the item is not found in the Supply table,
I
want the CF to apply. I have tried:

=$C4<vlookup($C4,Supply,1,False)as well as many other combos to no
avail. What is the formula. TIA

Greg