Conditional format ISERROR()

[Pal]

I am trying to conditional format a NA() statement.
I am using the formula is ISERROR() .
But how can I get it to look at its self? So if A1=#N/A then make font
color A1=white.
I have tried doing this with an cell value in the parenthesis but when I
copied down
all the rows the conditional format kept the absolute cell reference.

I have a large range of cells that I want to conditional format in this way.

Thanks
Pal

 

[Bob Phillips]

=ISNA(A1) or

=ISERROR(A1)

or am I missing something?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Ken Wright]

Take the $ signs off when you put the format on.

Select the whole of Col A by clicking on the column header. Hit Format / Cond
Fomttg, change cell value is to Formula is and put in =ISERROR(A1), choose your
font and you are done. It will apply it relatively to every cell in Col A.

 

[Ken Wright]

Probably only that the default when using the range selector is an absolute
reference I would guess. Pound to a penny on it.

 

[Pal]

First I could not do the entire column only a range.
But I found it would automatically place an " " around the ISERROR(J47).
I had to remove the quotes inorder to get it to work correctly.


I found that