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

Posts
1
Registration date
Tuesday June 10, 2014
Status
Member
Last seen
June 10, 2014
- - Latest reply: TrowaD
Posts
2576
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 10, 2019
- Jun 10, 2014 at 11:31 AM
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?
See more 

1 reply

Posts
2576
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 10, 2019
383
0
Thank you
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