I have a formula that works fine but...
some of the cells show #values, what i would like to do is conditional
formatting them to white font if = #values.
Any pointers?
many thanks
Ron Coderre - 10 Jun 2007 19:23 GMT
Try this:
Select the cells to be impacted
(I'll assume A1:A10, with A1 as the active cell)
From the Excel main menu:
<format><conditional formatting>
Condition_1
Formula is: =ISERROR(A1)
Click the [Formatting] button.....set the White font....Click the [OK]
buttons.
Does that help?
***********
Regards,
Ron
XL2002, WinXP
> I have a formula that works fine but...
>
[quoted text clipped - 4 lines]
>
> many thanks
Dave Peterson - 10 Jun 2007 19:23 GMT
You could modify the formula so that you don't see the error:
=if(iserror(yourformula),"",yourformula)
or you could use format|Conditional formatting.
Select the range of cells (say A1:A99) and with A1 the activecell:
Format|conditional formatting
formula is:
=iserror(a1)
And give it that white font on white fill.
> I have a formula that works fine but...
>
[quoted text clipped - 4 lines]
>
> many thanks

Signature
Dave Peterson
T. Valko - 10 Jun 2007 19:24 GMT
Try this.
Assume the range of cells in question is A1:A10
Select the range A1:A10
Goto the menu Format>Conditional Formatting
Formula Is:
To hide *only* the #VALUE! errors (all others will still be displayed):
=ERROR.TYPE(A1)=3
To hide *all* errors:
=ISERROR(A1)
Click the Format button
Set the font color to be the same as the fill color
OK out
Biff
>I have a formula that works fine but...
>
[quoted text clipped - 4 lines]
>
> many thanks
Dewi... - 10 Jun 2007 19:32 GMT
> I have a formula that works fine but...
>
[quoted text clipped - 4 lines]
>
> many thanks
Thanks to both for the very quick reply and the solution, thanks.