"conditional formatting" "#values"

[Dewi...]

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

 

[Guest]

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

 

[Dave Peterson]

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.

 

[T. Valko]

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

 

[Dewi...]

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

Thanks to both for the very quick reply and the solution, thanks.