Google Sheet accept colour from neighbour cell

Question

I wanted to know if I can solve this little problem in Google spreadsheets with conditional formatting but without a script.

Question 1: a blank Cell A1 has a red background colour and I change it to green manually. How can I get cell B1 to change from red to green too without touching it?

Answer 1

Google Sheets doesn't have a built-in feature that detects cell background changes. The alternative is to use a script, like the one on Google Spreadsheet: Script to Change Row Color when a cell changes text;