Cell colouring

Posted by Jean-Francois Burguet on February 15, 2002 6:55 AM

Hello Mr. Excel,

Your help would be most appreciated: I wish to change the background of a cell based on the background color of another cell. That simple but stuck nonetheless. Surely it will be a breeze for you.

Thanks a zillion !

JFB in Milan, Italy

Posted by will riley on February 15, 2002 8:03 AM

JFB

You could use the same conditional cell formatting
formula you used to turn your original cell to a different colour.

For example, if cell b1 has conditional formattingf that says if cell b1 value =1 then turn the cell red, you could have conditional formatting in cell b2 that said if cell b1 = 1
then turn the cell red...

Obvoiusly you can write a more complex formula that results in the format being dependent on more cell values than just one cell.

hope that helps,

will.

Posted by JFB on February 16, 2002 1:52 AM

Thanks Will,

What I was actually asking is the syntax of the formula to use if the following case :

Imagine cell A1 has either a blue or red background. What formula should I use for example to make B1's background

green if A1 is green
black if A1 is red

Can the formula be part of the cell or should it be included in a VBA module ? Thanks !!

JFB