conditional format on cells using VLOOKUP
 

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

conditional format on cells using VLOOKUP
 

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

conditional format on cells using VLOOKUP
 

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

conditional format on cells using VLOOKUP
 

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

conditional format on cells using VLOOKUP
 

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


"Niek Otten" wrote:

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

conditional format on cells using VLOOKUP
 

One way:

With cell A1 active:

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

In article ,
CEG wrote:

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.