This is a pretty comprehensive site for color breakout.

http://www.mvps.org/dmcritchie/excel/colors.htm

However, using colors for flags can be more trouble than it is worth. It
might be better to use a helper column or row. i.e. a column or row outside
the normal block of cells used for the database. You can then use an
unlimited combination of characters to identify the columns or rows within
the database area that need some action taken. Then you do not have to be
concerned about another user's system capabilities.



"ker_01" wrote in message
...
XL2003 on XP

I'm color coding a range of cells in my worksheet, which I'm then
exporting
(in chunks) as EMF files to be uploaded into Visio and paired with
specific
shapes as status indicators.

I'm using most of the built-in colors (vb blue, cyan, green, magenta, red,
yellow) but that wasn't enough distinctly colors to cover my target
categories, so I added a few mo

My_vbOrange = RGB(255, 128, 0)
My_vbDarkGreen = RGB(0, 128, 0)
My_vbDrkPurple = RGB(255, 0, 255)
My_vbLtPurple = RGB(90, 90, 255)
My_vbPuke = RGB(128, 128, 0)
My_vbOcean = RGB(64, 128, 128)
My_vbRose = RGB(180, 60, 95)
My_vbBrown = RGB(255, 128, 0)

I then use a select case statement for each value to determine which color
to use as the cell fill.

When I run my code, most of the colors appear to work as expected (orange,
rose, ocean all show up). However, I just noticed that my two purples are
not
differentiating on the worksheet- they are both exactly the same color of
pink (same as pink on the color picklist).

My goal was to use colors that were more differentiated than the built in
set, but without actually changing the pallet (in case anyone else uses
this
workbook, I don't want to cause other unforeseen problems with them
changing
workbook colors and affecting my pallet).

Am I stuck just using the default colorindex pallet set? Also, why are
some
of my colors working and not others?

Thanks,
Keith