You need to set up a custom format

Format - Cells - Number - Custom

[Green]#0_);[Red]#0

if you want parenthesis around the negaive numbe then use this

[Green]#0_);[Red](#0)

" wrote:

If I have a group of equations with answers that are both positive and
negative is there a way to have the equations that provide a negative number
automatically show up in red lettering and positive show up in green letters.