P
Patty
I am wondering if its possible to have a formula that would automatically put the font color as red if its a negative number?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
not a formula but use 'Format - Conditional Format' for this
not a formula but use 'Format - Conditional Format' for this
D
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.
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.
S
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
Number or Currency. You can choose whether to show negative numbers as red.
Stan Scott
New York City
put the font color as red if its a negative number?Patty said:I am wondering if its possible to have a formula that would automatically