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
--
David Biddulph

"Kevin V." <Kevin wrote in message
...
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).