conditional formating iserror isna

[doyree]

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!!

 

[T. Valko]

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 Format>Conditional 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

 

[doyree]

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

thank you!

 

[T. Valko]

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.