Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2007

Tip: Looking for answers? Try searching our database.

"conditional formatting" "#values"

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dewi... - 10 Jun 2007 19:10 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.