Programatically dim (lighten the color) of a cell.

Posted to microsoft.public.excel.programming

Jeremy Gollehon[_3_] Jeremy Gollehon[_3_] is offline

external usenet poster

Posts: 9

Programatically dim (lighten the color) of a cell.

I know I can read the RGB value of a color in VBA.

Is there a consistent way to do a calculation on those values to visually
return the same color but lighter (dimmer)?

Thanks,
Jeremy

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Changing font color of protected cells programatically	Nigel	Excel Discussion (Misc queries)	6	September 13th 08 12:32 PM
can I lighten background page numbers	LA Horowitz	Excel Discussion (Misc queries)	2	January 18th 08 02:06 AM
can i access the cell colour programatically? eg if cell is blue	Tony2Far	Excel Discussion (Misc queries)	2	August 9th 06 06:50 PM
programatically color fonts and auto sorting	[email protected]	Excel Programming	2	December 26th 05 07:03 AM
Excel: is there a way I can lighten the fill colors in a cell?	Bob Tourkow	Excel Discussion (Misc queries)	1	September 15th 05 02:27 PM

All times are GMT +1. The time now is 05:50 AM.

Menu

About Us