Change cell background depending on other cell color or text

[Ricky_J]

Hello all,

I've been trying to figure out how to change background color of a cell depending on text or color result of another cell.
For example, cell B8 has a drop down with a text selection which is color coded. Depending on the selection on B8, i want D7 to take the same color as B8.





I want to apply the same to other cell independently. I dont want one selection to affect other cells with same conditions.
For example i dont want selection on F8 which would change color on H7 to affect color on D7.



I looked online for a while and everything seem to be pointing me toward using conditional formatting.
I tried to use conditional formatting to no avail. I can’t get each selection to work independently.



I am not knowledgeable to know if there is another solution available.
Hoping that one of you guys can help me out with it.

Thank you

 

[Special-K99]

Cells cannot detect the colour of other cells using formulas, you need VBA to do this.
However, if the cell is coloured by Conditional Formatting then you can just use the same conditions that set the other cell.

 

[Ricky_J]

Thanks for the info. I will just do without it then.
If I understand i would have to do 4 rules for each cell i want to apply the color change and that will take too much time.

Thanks again for the help.

 

[Special-K99]

You need one rule for each colour.
If you want a white colour then you dont need a ruleas cells are usually white by default.

 

[Ricky_J]

I created a rule for each color problem is that I can't apply that conditional formatting to only one cell.
For example i want cell H7 to take the color of cell H8 without interfering with a color use on cell D7
https://drive.google.com/open?id=1JENgkzI9aaXQa6BjcOQBLGKFULTlmOeC
https://drive.google.com/open?id=1jFiLz62sr9-pyWoPkTQy3SZGhozBwfQg
https://drive.google.com/open?id=1775HJU-gYTW70ClHCke6RulyKrnxGIQr