Using Conditional Formatting will allow a greater range of colors:
Format Conditional Formatting... Value is less than 0 Format Font
Color
and pick your color
--
Gary''s Student - gsnu2007i
"wilchong via OfficeKB.com" wrote:
I have a question regarding the color in Excel. In normal time, if I want
the negative number shown in Red color, then I will formate a cell with【#,
##0;[Red] (#,##0)】. My question is that what happen if I want some other
color apart from the mainstream color (e.g black, green etc), how can I
easily formate it? What I mean is there any special color index code which I
can fill to the Excel formula, instead of just put [Red].
Many thanks,
Wilchong
--
Message posted via http://www.officekb.com