Use the function ISNA to test the cell

Regards

Trevor


"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