C
ccarolla
I can hide zeroes but I also need to hide negative values as well. How can I
get negatives values to hide?
get negatives values to hide?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bernard Liengme
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
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
J
jayd77
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
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
C
ccarolla
that worked. thanks
Bernard Liengme said: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