Conditional formatting problem

N

Nick Xylas

I am trying to put conditional formatting onto some cells in Excel
2002, so that if they return an error, the font color changes to white,
effectively rendering the #VALUE! errors I've been getting in some
cells invisible. I set the condition to ="ISERROR" and the font color
to white and...nothing happened! Any idea what went wrong?
 
B

Bob Phillips

Select the cells and use =ISERROR(A1), where A1 is the first cell.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
N

Nick Xylas

Bob said:
Select the cells and use =ISERROR(A1), where A1 is the first cell.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
Click to expand...

Whoo-hoo, it worked! Thanks.
 
G

Gord Dibben

Nick

Yes, it works but wouldn't you be better off dealing with errors instead of
hiding them?

Hidden errors will screw up any calculations if those cells are included.

i.e. =SUM(A1:A10) will throw an error of its own if any cell in A1:A10 has an
error.


Gord Dibben MS Excel MVP
 
N

Nick Xylas

Gord said:
Nick

Yes, it works but wouldn't you be better off dealing with errors instead of
hiding them?
Click to expand...
I was on a deadline. Now I can go back and fix it properly.
 
Top