Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting & Using Sheet Names or Index in VBA code | New Users to Excel | |||
Custom Color/Color Index | Excel Discussion (Misc queries) | |||
nested color index within sumproduct | Excel Worksheet Functions | |||
Chart axes color index vs font color index | Charts and Charting in Excel | |||
How to color automatically color code sums in cells | Charts and Charting in Excel |