LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 395
Default Working with colors (default and custom)

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Default Colors Synergy Excel Discussion (Misc queries) 0 October 15th 08 12:00 AM
Used drawing colors in shapes....lost default colors for "Fill Col Lai704 Excel Discussion (Misc queries) 1 August 20th 08 04:45 AM
restoring default fill colors, & saving with a custom color scheme WiFiMike2006 Excel Discussion (Misc queries) 3 March 28th 07 06:37 PM
Colors as Default Setting up and Configuration of Excel 14 September 7th 06 02:47 PM
chart default colors wendyeyes Charts and Charting in Excel 1 July 30th 05 04:21 PM


All times are GMT +1. The time now is 04:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"