I have a budget page in excel and when the balance gets to zero sometimes the
zero is red. It is confusing because only negatives should be red. How do I
get all my zero balances to be black and reds start at -.01?

I'll bet there's a rounding thing. The "zero" might actually be negative but
less than half a cent, like -$0.003. Therefore it shows up as a red "zero".

You could use a rounding function to make sure there are no fractional
pennies in your calculations:

=ROUND(<value>,2)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"kerryd73" <(E-Mail Removed)> wrote in message
news:45894584-7327-44A5-9523-(E-Mail Removed)...
>I have a budget page in excel and when the balance gets to zero sometimes
>the
> zero is red. It is confusing because only negatives should be red. How
> do I
> get all my zero balances to be black and reds start at -.01?