Color Index Code, is there any thing like that?
 

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

Color Index Code, is there any thing like that?
 

Try

# ##0;[Color n] (#,##0)

Where n is the number of a colour in the Excel colour palette (1 - 56)

Mike

"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

Color Index Code, is there any thing like that?
 

I think you can have the primary colours, red, green, blue, yellow as well
as black and white, but none of the others.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"wilchong via OfficeKB.com" <u43231@uwe wrote in message
news:848508d51a33a@uwe...
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

Color Index Code, is there any thing like that?
 

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