Vista - Free stuff: The Excel color index as table

03-09-2009

I don't know why I always write such nerd stuff, but I know that the
following table
show the Excel colors as VBS code; oExcelSheet.Cells(i,
1).Interior.ColorIndex= i
(for 1 to 56). The order follows the Excel-paint-box (5 vertical and 8
horizontal) colors.

The last row show six other colors which isn't found in the default
paint-box.

Example: Color index to "#800000" is 9 (same color as index 30),
and index 9 reffer to the same color as the Excel-paint-box in second
row, first column

Code:

1      #000000	43     #993300	52     #333300	51     #003300	49
#003366	11(25) #000080	55     #333399	56     #333333
9 (30) #800000	46     #FF6600	12     #808000	10     #008000	14(31)
#008080	5 (32) #0000FF	47     #666699	16     #808080
3      #FF0000	45     #FF9900	43     #99CC00	50     #339966	42
#33CCCC	41     #3366FF	13(29) #800080	48     #969696
7 (26) #FF00FF	44     #FFCC00	6 (27) #FFFF00	4      #00FF00	8 (28)
#00FFFF	33     #00CCFF	54(18) #993366	15     #C0C0C0
38     #FF99CC	40     #FFCC99	36     #FFFF99	35     #CCFFCC	34(20)
#CCFFFF	37     #99CCFF	39     #CC99FF	2      #FFFFFF

22     #FF8080		19     #FFFFCC		23     #0066CC	17     #9999FF	24
#CCCCFF	21     #660066

Benny,
PS: If your google reader spoil the above lines, you can see
this GIF instead: http://www.fineraw.com/stuff/free/XLS_COLOR.GIF

03-09-2009	#1 (permalink)
Benny Pedersen n/a posts	Free stuff: The Excel color index as table I don't know why I always write such nerd stuff, but I know that the following table show the Excel colors as VBS code; oExcelSheet.Cells(i, 1).Interior.ColorIndex= i (for 1 to 56). The order follows the Excel-paint-box (5 vertical and 8 horizontal) colors. The last row show six other colors which isn't found in the default paint-box. Example: Color index to "#800000" is 9 (same color as index 30), and index 9 reffer to the same color as the Excel-paint-box in second row, first column Code: 1 #000000 43 #993300 52 #333300 51 #003300 49 #003366 11(25) #000080 55 #333399 56 #333333 9 (30) #800000 46 #FF6600 12 #808000 10 #008000 14(31) #008080 5 (32) #0000FF 47 #666699 16 #808080 3 #FF0000 45 #FF9900 43 #99CC00 50 #339966 42 #33CCCC 41 #3366FF 13(29) #800080 48 #969696 7 (26) #FF00FF 44 #FFCC00 6 (27) #FFFF00 4 #00FF00 8 (28) #00FFFF 33 #00CCFF 54(18) #993366 15 #C0C0C0 38 #FF99CC 40 #FFCC99 36 #FFFF99 35 #CCFFCC 34(20) #CCFFFF 37 #99CCFF 39 #CC99FF 2 #FFFFFF 22 #FF8080 19 #FFFFCC 23 #0066CC 17 #9999FF 24 #CCCCFF 21 #660066 Benny, PS: If your google reader spoil the above lines, you can see this GIF instead: http://www.fineraw.com/stuff/free/XLS_COLOR.GIF
My System Specs

Similar Threads
Thread	Forum
Error when updating Access table from Excel Worksheet	VB Script
Exporting MsSQL table to Excel using vbScript?	VB Script
Re: Color to Excel sheet? #FF0000 (255,0,0)	VB Script
Reading SQL Table into Excel and calculating/inserting group line (with VBA)?	VB Script
dynamic table excel 2007?	Vista General