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

Fill tringle in a cell with color 1
Change row colors based on a cell value 1
Function for summing or counting cells based on a specified fill color 3
Pasting a range to a single cell 0
Word macro that can call cells out of Excel for a find and replace 0
Cell Color Recognition and Summing of Data Within a Specified Colo 1
How do I convert shading to highlighting for specific colors 8
Conditional formatting code 1

Top