Conditional formatting problem

  • Thread starter Thread starter Nick Xylas
  • Start date Start date
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?
 
Select the cells and use =ISERROR(A1), where A1 is the first cell.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
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.
 
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
 
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.
 
Back
Top