Change a cell colour based on another cell's color

[Andieb]

Hi what I need is the following:

If cell A1 is colored red (RGB255, 0, 0) then makes this cell (D1) also red, if it's green (RGB0, 204, 0) then also make it green.

The cells that are being changed color have data in them or I may have to input data at some stage, so I don't want the data in the cells to be affected.

Thanks to everyone in advance... Andie

[FDibbins]

Hi and welcome ot the forum

excel cannot "see" colors because colors are formatting, not data. excel works with data, formatting is just cosmetic appearance. Is there some logic that determines what color the 1st cell will be? If so we could use that same logic to change the 2nd cell.

Failing that, you will need someone to put some VBA together for you for this

[Andieb]

Thanks so much for your quick reply!

I guessed as much, unfortunately it's all about the color and not the content (it's a kind of staff roster showing availability - GREEN available and RED not available). I'll probably post something in the forum re VBA, although it's a bit beyond what I usually get into....

Thanks again

[dredwolf]

If your (original) cell color is based on availabilty, how did you get it assigned? (this is what I believe FDibbins was trying to point out)
Using the same logic, you can get the NEW cell to highlight in the same color as the original

Edit-
It's probably even the same calculation, just adjusted for cell placement