conditional formatting with a twist?

  • Thread starter Thread starter bigD
  • Start date Start date
B

bigD

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.
 
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.
 
Absolutely awesome. I can't you how much easier this is going to make
my life!

Thanks,


Bruce

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.

--
Regards from Virginia Beach,

Earl Kiosterudwww.smokeylake.com



Hi,
Click to expand...
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.

Big D.- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...
 
Back
Top