hello
please help me with iserror or isna with conditinal formating

i've got a whole column with vlookup,
a
1234
114315
123512
#N/A
1231

i wanted to fill box for those #N/A
i clicked the column A and tried;

=ISNA(A1), =ISNA($A1)
=ISERROR(A1), =ISERROR($A1)
=ISNUMBER(A1), =ISNUMBER($A1)
NOTHING WORKS!!!

can someone tell me why this isn't working?

thank you!!

Let's assume your data is in the range A1:A5

Select the range A1:A5 so that A1 is the active cell. The active cell is the
one that is not "blueish" in color. Select cell A1 then right click and hold
the mouse button and drag down to A5 then release the mouse button. Cell A1
will be the active cell.

Goto the menu FormatConditional Formatting
Select Formula Is
Enter this formula in the little box on the right:

=ISNA(A1)

Click the Format button
Select the style(s) desired
OK out

--
Biff
Microsoft Excel MVP


"doyree" wrote in message
...
hello
please help me with iserror or isna with conditinal formating

i've got a whole column with vlookup,
a
1234
114315
123512
#N/A
1231

i wanted to fill box for those #N/A
i clicked the column A and tried;

=ISNA(A1), =ISNA($A1)
=ISERROR(A1), =ISERROR($A1)
=ISNUMBER(A1), =ISNUMBER($A1)
NOTHING WORKS!!!

can someone tell me why this isn't working?

thank you!!

I guess i can't just select the whole column but just use drag.

thank you!

"T. Valko" wrote:

Let's assume your data is in the range A1:A5

Select the range A1:A5 so that A1 is the active cell. The active cell is the
one that is not "blueish" in color. Select cell A1 then right click and hold
the mouse button and drag down to A5 then release the mouse button. Cell A1
will be the active cell.

Goto the menu FormatConditional Formatting
Select Formula Is
Enter this formula in the little box on the right:

=ISNA(A1)

Click the Format button
Select the style(s) desired
OK out

--
Biff
Microsoft Excel MVP


"doyree" wrote in message
...
hello
please help me with iserror or isna with conditinal formating

i've got a whole column with vlookup,
a
1234
114315
123512
#N/A
1231

i wanted to fill box for those #N/A
i clicked the column A and tried;

=ISNA(A1), =ISNA($A1)
=ISERROR(A1), =ISERROR($A1)
=ISNUMBER(A1), =ISNUMBER($A1)
NOTHING WORKS!!!

can someone tell me why this isn't working?

thank you!!

You can select the whole column but are you *actually* using the whole
column?

Depending on what version of Excel you're using the whole column could be
either 1,000,000+ , 65,000+, or 16,000+ rows.

--
Biff
Microsoft Excel MVP


"doyree" wrote in message
...
I guess i can't just select the whole column but just use drag.

thank you!

"T. Valko" wrote:

Let's assume your data is in the range A1:A5

Select the range A1:A5 so that A1 is the active cell. The active cell is
the
one that is not "blueish" in color. Select cell A1 then right click and
hold
the mouse button and drag down to A5 then release the mouse button. Cell
A1
will be the active cell.

Goto the menu FormatConditional Formatting
Select Formula Is
Enter this formula in the little box on the right:

=ISNA(A1)

Click the Format button
Select the style(s) desired
OK out

--
Biff
Microsoft Excel MVP


"doyree" wrote in message
...
hello
please help me with iserror or isna with conditinal formating

i've got a whole column with vlookup,
a
1234
114315
123512
#N/A
1231

i wanted to fill box for those #N/A
i clicked the column A and tried;

=ISNA(A1), =ISNA($A1)
=ISERROR(A1), =ISERROR($A1)
=ISNUMBER(A1), =ISNUMBER($A1)
NOTHING WORKS!!!

can someone tell me why this isn't working?

thank you!!