Select the range (or column)
A) Use Format|Conditional Formatting
Specify "Cell value", "Is less than" "0" and make the font white (or colour
of cell background) that it disappears
or B) use Format | Custom Format using something like $#,##0.00;""
best wishes
I don't know if this is the answer your looking for. You could do some
conditional formatting where if the value is negative you change the
format of the text to white so you can't see the numbers. Format --
Conditional Formatting
Cell Value is less than 0
Select the range (or column)
A) Use Format|Conditional Formatting
Specify "Cell value", "Is less than" "0" and make the font white (or colour
of cell background) that it disappears
or B) use Format | Custom Format using something like $#,##0.00;""
best wishes
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
