Try formula of =COUNTIF(A1,"#N/A")0

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"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