PDA

View Full Version : ColorIndex Names



JimFuller1
August 7th, 2006, 13:23
I know that there are ColorIndex numbers associated with Excel colors. Does anyone know if there is a list of ColorIndex names like Red, Green, etc.?

Thanks,
Jim

Krishnakumar
August 7th, 2006, 13:32
Does this (http://www.mvps.org/dmcritchie/excel/colors.htm) help you?

JimFuller1
August 7th, 2006, 13:42
Krishnakumar,

Thanks I think that'll do me. But, that was waaaay more than I ever wanted to know.

LOL,
Jim

royUK
August 7th, 2006, 13:57
Do you mean?

vbBlack
vbRed
vbGreen
vbYellow
vbBlue
vbMagenta
vbCyan
vbWhite

Dave Hawley
August 7th, 2006, 14:23
See: Interior Cell Color by Index or Name (http://www.ozgrid.com/VBA/ReturnCellColor.htm)

JimFuller1
August 7th, 2006, 14:28
Thanks Dave,

Is there a property that returns the color name by any chance or are these names culled from the Microsoft literature?

Jim

Dave Hawley
August 7th, 2006, 14:36
No Property that I know of. There is a chart in the VBA help though under PatternColorIndex Property

Jack in the UK
August 7th, 2006, 17:16
Does this list help?

jiuk

interior font HTML bgcolor= Red Green Blue Color
Black [Color 1] #000000 #000000 0 0 0 [Black]
White [Color 2] #FFFFFF #FFFFFF 255 255 255 [White]
Red [Color 3] #FF0000 #FF0000 255 0 0 [Red]
Green [Color 4] #00FF00 #00FF00 0 255 0 [Green]
Blue [Color 5] #0000FF #0000FF 0 0 255 [Blue]
Yellow [Color 6] #FFFF00 #FFFF00 255 255 0 [Yellow]
Magenta [Color 7] #FF00FF #FF00FF 255 0 255 [Magenta]
Cyan [Color 8] #00FFFF #00FFFF 0 255 255 [Cyan]
[Color 9] [Color 9] #800000 #800000 128 0 0 [Color 9]
[Color 10] [Color 10] #008000 #008000 0 128 0 [Color 10]
[Color 11] [Color 11] #000080 #000080 0 0 128 [Color 11]
[Color 12] [Color 12] #808000 #808000 128 128 0 [Color 12]
[Color 13] [Color 13] #800080 #800080 128 0 128 [Color 13]
[Color 14] [Color 14] #008080 #008080 0 128 128 [Color 14]
[Color 15] [Color 15] #C0C0C0 #C0C0C0 192 192 192 [Color 15]
[Color 16] [Color 16] #808080 #808080 128 128 128 [Color 16]
[Color 17] [Color 17] #9999FF #9999FF 153 153 255 [Color 17]
[Color 18] [Color 18] #993366 #993366 153 51 102 [Color 18]
[Color 19] [Color 19] #FFFFCC #FFFFCC 255 255 204 [Color 19]
[Color 20] [Color 20] #CCFFFF #CCFFFF 204 255 255 [Color 20]
[Color 21] [Color 21] #660066 #660066 102 0 102 [Color 21]
[Color 22] [Color 22] #FF8080 #FF8080 255 128 128 [Color 22]
[Color 23] [Color 23] #0066CC #0066CC 0 102 204 [Color 23]
[Color 24] [Color 24] #CCCCFF #CCCCFF 204 204 255 [Color 24]
[Color 25] [Color 25] #000080 #000080 0 0 128 [Color 25]
[Color 26] [Color 26] #FF00FF #FF00FF 255 0 255 [Color 26]
[Color 27] [Color 27] #FFFF00 #FFFF00 255 255 0 [Color 27]
[Color 28] [Color 28] #00FFFF #00FFFF 0 255 255 [Color 28]
[Color 29] [Color 29] #800080 #800080 128 0 128 [Color 29]
[Color 30] [Color 30] #800000 #800000 128 0 0 [Color 30]
[Color 31] [Color 31] #008080 #008080 0 128 128 [Color 31]
[Color 32] [Color 32] #0000FF #0000FF 0 0 255 [Color 32]
[Color 33] [Color 33] #00CCFF #00CCFF 0 204 255 [Color 33]
[Color 34] [Color 34] #CCFFFF #CCFFFF 204 255 255 [Color 34]
[Color 35] [Color 35] #CCFFCC #CCFFCC 204 255 204 [Color 35]
[Color 36] [Color 36] #FFFF99 #FFFF99 255 255 153 [Color 36]
[Color 37] [Color 37] #99CCFF #99CCFF 153 204 255 [Color 37]
[Color 38] [Color 38] #FF99CC #FF99CC 255 153 204 [Color 38]
[Color 39] [Color 39] #CC99FF #CC99FF 204 153 255 [Color 39]
[Color 40] [Color 40] #FFCC99 #FFCC99 255 204 153 [Color 40]
[Color 41] [Color 41] #3366FF #3366FF 51 102 255 [Color 41]
[Color 42] [Color 42] #33CCCC #33CCCC 51 204 204 [Color 42]
[Color 43] [Color 43] #99CC00 #99CC00 153 204 0 [Color 43]
[Color 44] [Color 44] #FFCC00 #FFCC00 255 204 0 [Color 44]
[Color 45] [Color 45] #FF9900 #FF9900 255 153 0 [Color 45]
[Color 46] [Color 46] #FF6600 #FF6600 255 102 0 [Color 46]
[Color 47] [Color 47] #666699 #666699 102 102 153 [Color 47]
[Color 48] [Color 48] #969696 #969696 150 150 150 [Color 48]
[Color 49] [Color 49] #003366 #003366 0 51 102 [Color 49]
[Color 50] [Color 50] #339966 #339966 51 153 102 [Color 50]
[Color 51] [Color 51] #003300 #003300 0 51 0 [Color 51]
[Color 52] [Color 52] #333300 #333300 51 51 0 [Color 52]
[Color 53] [Color 53] #993300 #993300 153 51 0 [Color 53]
[Color 54] [Color 54] #993366 #993366 153 51 102 [Color 54]
[Color 55] [Color 55] #333399 #333399 51 51 153 [Color 55]
[Color 56] [Color 56] #333333 #333333 51 51 51 [Color 56]

Jack in the UK
August 7th, 2006, 17:20
Also:
I use colours quote a bit and this site - page is very good for reference materials

jiuk

TRY -- Click HERE For the link - jiuk (http://www.geocities.com/davemcritchie/excel/colors.htm)

JimFuller1
August 7th, 2006, 21:38
Thanks guys,

Should I be on the lookout for a "ColorName" property in the new Excel?

Jim

Aaron Blood
August 7th, 2006, 21:49
This is how I do it now...
Color Enumeration (http://www.ozgrid.com/forum/showthread.php?t=53791)


...and this is probably more info than you'd want to know.
XL-Logic Colors.zip (http://www.xl-logic.com/xl_files/vba/colors.zip)

JimFuller1
August 7th, 2006, 22:04
Thanks Aaron,

You're the cause of all my questions already when I read that post several days ago. I added that code to my Personal.xls and intend to use it. Now I'm just curious about the 'official' names that Excel may recognize. Since only a few have disclosed 'official' names, I guess I'll have to wait to add that column to my Color Index worksheet.

I like the way you approach the problem though by just creating your own names.

Thanks again,
Jim

Aaron Blood
August 7th, 2006, 22:40
Thanks Aaron,

You're the cause of all my questions already when I read that post several days ago. I added that code to my Personal.xls and intend to use it. Now I'm just curious about the 'official' names that Excel may recognize. Since only a few have disclosed 'official' names, I guess I'll have to wait to add that column to my Color Index worksheet.

I like the way you approach the problem though by just creating your own names.

Thanks again,
Jim

I wouldn't put that code in the Personal.xls workbook, that is, unless you intend to just use that as a convenient storage spot for easy pasting into your app.

JimFuller1
August 7th, 2006, 23:15
I keep a lot of stuff in my Personal.xls, some macros, some commented UDFs, some sheets with formulas. Storage more than anything. Code gets copied to other projects or if it is needed frequently enough, just executed from Personal.xls. My most used macro from Personal.xls is one of the simplest. It centers across a selected range (don't get me started).