Use "Formula is" Instead of "Cell value is". The formula (for cell A1) is:

=ISNA(A1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"CEG" wrote in message ...
|I want to highlight the cells that do not get a result from the VLOOKUP
| function. I tried setting the conditional format to Cell Value = "N/A" (and
| other variations) but with no luck.
| --
| CG