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

Use "Formula is" Instead of "Cell value is". The formula (for cell A1) is:

=ISNA(A1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"CEG" <(E-Mail Removed)> wrote in message news:B980101D-9D60-46CB-B319-(E-Mail Removed)...
|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)

"CEG" <(E-Mail Removed)> wrote in message
news:B980101D-9D60-46CB-B319-(E-Mail Removed)...
>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

Use the function ISNA to test the cell

Regards

Trevor


"CEG" <(E-Mail Removed)> wrote in message
news:B980101D-9D60-46CB-B319-(E-Mail Removed)...
>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

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" <(E-Mail Removed)> wrote in message news:B980101D-9D60-46CB-B319-(E-Mail Removed)...
> |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
>
>
>

One way:

With cell A1 active:

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

In article <B980101D-9D60-46CB-B319-(E-Mail Removed)>,
CEG <(E-Mail Removed)> 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.