conditional format on cells using VLOOKUP

[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.

 

[Niek Otten]

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

 

[Bob Phillips]

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)

 

[Trevor Shuttleworth]

Use the function ISNA to test the cell

Regards

Trevor

 

[Guest]

Thanks for the quick reply...I knew there had to be a simple answer!

 

[JE McGimpsey]

One way:

With cell A1 active:

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