Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Default Colors | Excel Discussion (Misc queries) | |||
Used drawing colors in shapes....lost default colors for "Fill Col | Excel Discussion (Misc queries) | |||
restoring default fill colors, & saving with a custom color scheme | Excel Discussion (Misc queries) | |||
Colors as Default | Setting up and Configuration of Excel | |||
chart default colors | Charts and Charting in Excel |