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 / March 2008

Tip: Looking for answers? Try searching our database.

conditional formatting with a twist?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bigD - 25 Mar 2008 19:41 GMT
Hi,

I often produce medium sized tables in excel where numbers with a
value of less than 5 need to be suppressed, that is changed to a "-"
symbol. I could make a copy of the table and use an if formula to to
get the desired results, but this seems cumbersome. Is there anyway to
cludge Excel 2003 to format values less than five a given value to a
different symbol? Changing the font to white to supress the value is
not sufficient.

Thanks,

Big D.
Earl Kiosterud - 25 Mar 2008 20:10 GMT
Big,

Try this custom number format (Format - Cells - Number tab - Custom):

[<5]"-" ;General

This won't change the underlying value in the cell, just what's displayed in the cell.  I
think that's what you want.

Signature

Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

> Hi,
>
[quoted text clipped - 9 lines]
>
> Big D.
bigD - 26 Mar 2008 15:13 GMT
Absolutely awesome. I can't you how much easier this is going to make
my life!

Thanks,

Bruce

> Big,
>
[quoted text clipped - 25 lines]
>
> - Show quoted text -

Rate this thread:






 
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.