auto change font color in formula/cell

[Kevin V.]

How can I set up a formulated cell that changes the font color automatically
when the sum is less than or greater than a specific number? Green for
positive number ( greater), and red for a negitive number ( less than).

 

[David Biddulph]

Either Format Cells/ Custom: [Green]General;[Red]-General;General [if you
want the colours for positive and negative numbers] or
[Green][>2]General;[Red][<2]General;General if you want colours for greater
than or less than a defined number (or change General to your preferred
number format)

Or otherwise use Format/ Conditional Formatting/ Cell Value Is