M
Michael C.
I am doing monetary calculations in an excel spreadsheet (great place to do
that, huh?).
Sometimes the calculated value is $0.00. Which is not a problem. The problem
is that sometimes the value is displayed in red.
I want negative values to be displayed in red, but not Zero values.
I'm doing standard addition/subtraction of nothing smaller than $.01
(nothing that is a fraction of a cent).
So if the value reads $0.00, then it really IS $0.00 and not $0.001 or lower.
How can I stop the incorrect display of the zero value in red while keeping
the negative values red?
that, huh?).
Sometimes the calculated value is $0.00. Which is not a problem. The problem
is that sometimes the value is displayed in red.
I want negative values to be displayed in red, but not Zero values.
I'm doing standard addition/subtraction of nothing smaller than $.01
(nothing that is a fraction of a cent).
So if the value reads $0.00, then it really IS $0.00 and not $0.001 or lower.
How can I stop the incorrect display of the zero value in red while keeping
the negative values red?