How to Color a Cell Based on a Range of Cells with Colors

R

ron weasley

I am trying to setup a formula in one cell to look at a range of cells to see
if any are filled with colors. The range of cells contain numeric values and
I created a conditional format to make the cell color red or yellow. If the
range of cells are colored, then I want the one cell's format to change to
the same color. Can anyone help me determine a solution?
 
G

Gord Dibben

What are the rules for the range cells changing color?

Could you perhaps use the same rule(s) for the "one cell"?

Counting cells based upon colors created by Conditional Fomatting is not
very easy and requires quite a bit of VBA.

If you want to have a go at it see Chip Pearson's site.

http://www.cpearson.com/excel/CFColors.htm


Gord Dibben MS Excel MVP

On Tue, 12 Jan 2010 16:11:01 -0800, ron weasley <ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Excel Macro to automatically go to the right of the last colored cell 0
Function for summing or counting cells based on a specified fill color 2
Cell Color Recognition and Summing of Data Within a Specified Colo 1
In excel change color of a range of cells based on a cell value 1
Counting cells of a specific color 8
Counting Colors of Cells set by Conditional Formatting 2
format a range dependant on another cell 2

Top