Conditional formatting problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nick Xylas - 08 Jan 2007 14:47 GMT

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?

Reply to this Message

Bob Phillips - 08 Jan 2007 15:05 GMT

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

Signature

---
HTH

Bob

(change the xxxx to gmail if mailing direct)

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

Reply to this Message

Nick Xylas - 08 Jan 2007 15:23 GMT

> Select the cells and use =ISERROR(A1), where A1 is the first cell.
>
[quoted text clipped - 5 lines]
>
> (change the xxxx to gmail if mailing direct)

Whoo-hoo, it worked! Thanks.

Reply to this Message

Gord Dibben - 08 Jan 2007 18:05 GMT

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

>> Select the cells and use =ISERROR(A1), where A1 is the first cell.
>>
[quoted text clipped - 7 lines]
>
>Whoo-hoo, it worked! Thanks.

Reply to this Message

Nick Xylas - 16 Jan 2007 17:09 GMT

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

I was on a deadline. Now I can go back and fix it properly.

Reply to this Message

Rate this thread: