font color for negative numbers

[Guest]

I am wondering if its possible to have a formula that would automatically put the font color as red if its a negative number?

 

[Frank Kabel]

Hi
not a formula but use 'Format - Conditional Format' for this

 

[David McRitchie]

Hi Patty,
Is there anything wrong with the custom cell formatting.

Format, cells, number
choose one that has red, though I think it RED may have been left out
of some language versions, so you could always take the formatting that
matches what you want and use [RED] in the second part. semi-colon
is the US list separator.
Positive Numbers(default); Negative Numbers(default); Zero(All other numbers); Text
#,##0.00_);[Red](#,##0.00)

Custom Formatting (#custom)
http://www.mvps.org/dmcritchie/excel/formula.htm#custom

Using Formatting to Change the Way Numbers, Dates, Times, and Text Appear in Microsoft Excel
http://support.microsoft.com/default.aspx?scid=/support/excel/content/formats/default.asp

If you really want to use Conditional Formatting, I have a page
http://www.mvps.org/dmcritchie/excel/condfmt.htm
but it would certainly not be as efficient as custom cell formatting.
And Conditional Formatting is lot harder to keep track of what
you've done.

 

[Stan Scott]

You don't need a formula. Just use the Format menu command, and select
Number or Currency. You can choose whether to show negative numbers as red.

Stan Scott
New York City

I am wondering if its possible to have a formula that would automatically

put the font color as red if its a negative number?