Yes.
Select cell where u want apply conditional format and select Formula from
conditional format box and type below mentioned formula

=ISERROR(VLOOKUP(B1,$A$1:$A$100,1,0))

and set the format which format u want.

in this formula u need to change cell range
in that formula, Cell B1 is which cell u selected, and $A$1:$A$100 range is
list of names ( You can use Name list also).

Please do rate.

Regards


"pkeegs" wrote:

I would like to apply a conditional format into a cell, so that when I type a
name into that cell, if it doesn't exist on a separate list of names, the
condition will apply. Is it possible?