Conditional Formatting based on the fill color of a cell

I have searched high and low for an answer to this and I'm beginning to think it can't be done.

I am trying to format a cell fill color based on another cell's fill color. Simple right...?

Any help would be appreciated.

Hi,

It is feasible ... but an easier solution would be to rely on the conditions (if any) you have used to color the first cell ...

If the first cell is "manually" colored, then you need to get into VBA ...

HTH

Crap, That is what I was afraid of. The first cell is colored manually.

Still a little bit of hope ... with the numbers of different colors you are depending on, in the first cell ...

Originally Posted by JeanRage

Still a little bit of hope ... with the numbers of different colors you are depending on, in the first cell ...

Not sure I understand what you are sying here. Sorry.

As a first step, dealing with colors, take a look at Bob's UDF function ...
http://xldynamic.com/source/xld.ColourCounter.html

HTH

Originally Posted by JeanRage

As a first step, dealing with colors, take a look at Bob's UDF function ...
http://xldynamic.com/source/xld.ColourCounter.html

HTH

Thanks. I tried Bob's UDF function, but I'm not much of a programmer and I probably screwed it up cause it didn't work.

If you are only using 3 basic colors for your reference cell ...
does it mean your objective for the target cell is just to have the same color as the reference cell... ?

Originally Posted by JeanRage

If you are only using 3 basic colors for your reference cell ...
does it mean your objective for the target cell is just to have the same color as the reference cell... ?

Yes. That is absolutely correct.

Originally Posted by Shampoo Monkey

Hey mfrymyer,

I believe the question is why do you set the colors you do. What is the criteria that makes you choose one color over another.

It is a "purely manual" thing. I am a project manager and I have a need to be able to turn a cell to either yellow, red, or green based on whether a different cell's fill color has been changed "manually".

How many potential colors could you end up using for the "first" cell ... ?

Originally Posted by JeanRage

How many potential colors could you end up using for the "first" cell ... ?

3. Either Green, Yellow, or Red

Hi there, I've noticed this thread and found it particularly interesting. However, not being an Excel expert (by a long shot!) I don't fully understand it.

I too have two tables of data on the one worksheet. I'm using conditional formatting rules on the first table to determine the colour of the cells (red, green and yellow). This part is working fine.

However, I need the second, almost identical table to replicate the colours cell by cell. So, if a specific cell in table 1 is red the same cell (in the relative position) in table 2 also needs to be red. Is there a way of doing this? The file attached seems to be doing the right thing but I have no idea how to implement a macro.

Appreciate your help!

ian.

hello friends,
i was trying to make exactly same; "conditional format a cell, based on another cell's fill color"
but could not create it according to previous steps.
can any of you explain it simply please?

Awesome stuff, works great. Could this be changed to work for multiple columns? and Possible from another sheet, and even further, transpose the layout?
I have 2 client that demand the same spreadsheet be formatted their own preference. I need 1 sheet formatted left to right, but the other client wants to see the same info top to bottom. I already have my formulas transposed, but when we color cells, it's a pain to get that over. thanks in advance for any help.