Apply this formula in the conditional format: =ISERROR() Also: =ISNA()

Alternatively you could trap (eliminate) the #N/A error by adopting the
following form: =IF(ISERROR(VLOOKUP([your criteria]),"",VLOOKUP([your
criteria]))

Dave
--
Brevity is the soul of wit.


"Dave" wrote:

Is is possible to conditionally format a cell when using vlookup and the
returned value is #N/A.
Thanks,
Dave