change fill color of a range of cells based on color of a cell?

=?Utf-8?B?RGFyTWVsTmVs?=

Guest

Posts: n/a

2nd Mar 2006

I want to change the color of a range of cells based on the color of a
different cell. How do I do this. I tried conditional formatting but this
only lets me specify the color in the conditional formatting box. It does
not allow me to point that to a cell and a color reference.

For example - cell A1 is red - change cells A5-A8 to red. Cell B1 is green
- change cells B2-B11 green etc..

« Looping through Cells | Extensibility Library »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
In excel change color of a range of cells based on a cell value	kwitt	Microsoft Excel Worksheet Functions	1	18th Nov 2009 07:20 PM
Summing cells within a column based on cell fill color	Jim D.	Microsoft Excel New Users	2	8th Oct 2008 04:56 PM
How to Change fill color of cell based on value	r_fordjr@msn.com	Microsoft Excel Discussion	2	14th Dec 2006 01:53 PM
Is there a way to count cells in a range based on fill color?	=?Utf-8?B?ZWVoaW5tZA==?=	Microsoft Excel Worksheet Functions	2	16th Mar 2006 05:09 PM
Change fill color based on value of another cell in Excel	=?Utf-8?B?Rm9yZW5zaWNBY2NvdW50YW50?=	Microsoft Excel Programming	2	20th Dec 2005 06:08 PM