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: 1
Default want to change cell background using RGB data in a worksheet

I want to set up a worksheet with 1 column the colour name and have the
background of that cell be the colour. I also have a column for the Hex #
associated with that colour for the web. Also included are 3 more columns
each with the corrisponding RGB #'s (ie Column C = R, Column D = G, Column E
= B). Is there a formula that can take the data from each cell columns C,D,E
to create the fill colour for each corrisponding cell in column A?
(ie A3 = Dark Red, Columns CDE3 contain the RGB code for Dark Red, then A4 =
Crimson and CDE4 the RGB code for crimson).
 
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
How can I change worksheet background colour Mark Setting up and Configuration of Excel 2 January 5th 21 07:17 AM
Change background / color of chart worksheet? Maj_USA_Ret Charts and Charting in Excel 3 March 12th 10 04:05 PM
change background row color with change of date in a cell Urszula Excel Discussion (Misc queries) 5 May 17th 06 07:56 AM
How do I change worksheet background? Dawnvt Excel Discussion (Misc queries) 7 May 8th 06 10:01 PM
can't change cell background? Todd[_5_] Excel Programming 0 September 2nd 03 04:41 PM


All times are GMT +1. The time now is 11:24 AM.

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"