Changing cell background color based on another cells background [Closed]

Report
Posts
1
Registration date
Tuesday June 10, 2014
Status
Member
Last seen
June 10, 2014
-
TrowaD
Posts
2591
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
February 11, 2020
-
Hi guys. Quick question,

is there anyway to change a cell background color based on another cell background being a particular color?

I have a row with conditioning format that changes the background color based on a specific text.
I would like to add a cell at the end of each row that would change, say, green if all other cells background on that row were green.

Is this possible?

1 reply

Posts
2591
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
February 11, 2020
396
Hi Queo,

To change the background colour according to another cells colour, a macro is needed.

BUT since you use conditional format to change the colour of the other cells, you can combine them using the AND function for the final cell.

Example:
A1: =A1=1 then green
B1: =B1=1 then green
C1: =AND(A1=1,B1=1) then green

Best regards,
Trowa