conditional format on cells using VLOOKUP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Use "Formula is" Instead of "Cell value is". The formula (for cell A1) is:

=ISNA(A1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|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
 
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)
 
One way:

With cell A1 active:

CF1: Formula is =ISNA(A1)
Format1: <pattern>/<choose color>
 
Back
Top