Use a formula of

=ISNA(A2)

assuming A2 is the first cell selected.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


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