Conditional format ISERROR()

  • Thread starter Thread starter Pal
  • Start date Start date
P

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
 
=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)
 
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.
 
Probably only that the default when using the range selector is an absolute
reference I would guess. Pound to a penny on it. :-)
 
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
 
Back
Top