Red Formatting But Cell Value Equals Zero

Hey there,

Looking for any advice on why this is happening? I have a couple line-items that equal out to zero, however the balance in the available column is still showing as red? Any ideas?

Thank you,


I woudl guess there is a value there that is close to but not zero. -.00000000001. but the formatting makes it look like zero.

You shoudl add a round formulat to it. =Round(cell value,2)

1 Like

I’m sure richl is right about the cause, though out of curiosity what sheet are you seeing this happen in?

Me too. Let us know which solution you’re using, @brandonscottgardner.