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

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


"Dewi..." wrote:

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

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.



"Dewi..." wrote:
>
> 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

--

Dave Peterson

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..." <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>

On 10 Jun, 19:10, "Dewi..." <Dewi.W.Willi...@googlemail.com> wrote:
> 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.