Change cell color based on another cell color in Google Sheets

Question

I would like to change a particular cell color based on the specific cell color. (For ex: If A1 cell color is green then B1 background color should change to green if A2 cell color is red than B2 cell color should change to red. Kindly help me how to do that in google sheets. Thanks in advance.

Answer 1

this is not possible as you imagine it. however, this is:

let's say that if:

A2 cell color is RED because it's not empty/has a number/has specific text... then you can set color to be RED on B2 if A2 not empty/has a number/has specific text...

in such case, you use so-called custom formula. example:

also, you may be interested in: https://chrome.google.com/webstore/c