Changing cell background color based on another cells background
Closed
Queo
Posts
1
Registration date
Tuesday June 10, 2014
Status
Member
Last seen
June 10, 2014
-
Jun 10, 2014 at 04:34 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 10, 2014 at 11:31 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 10, 2014 at 11:31 AM
Related:
- Using which group you can change the cell background colour
- Notepad++ change background color - Guide
- Crimping colour code - Guide
- Viber background - Guide
- Change computer name cmd - Guide
- Change lg tv name - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jun 10, 2014 at 11:31 AM
Jun 10, 2014 at 11:31 AM
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
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
