Take a look at Format|Conditional formatting.

gtcarlsbad wrote:

How do I get the font color to change automatically depending on whether it
is a positive or negative number? Example: if negative auto change to red,
If positive number change to green, zero balance auto change to black.

--

Dave Peterson