Colour changing in rows determined by text in 2 different cells
Solved/Closed
kitchens
-
Mar 17, 2016 at 12:01 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 17, 2016 at 12:19 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 17, 2016 at 12:19 PM
Related:
- Colour changing in rows determined by text in 2 different cells
- 텐타클 락커 2 - Download - Adult games
- Five nights in anime 2 - Download - Adult games
- Rj45 colour code - Guide
- My cute roommate 2 - Download - Adult games
- Saints row 2 cheats - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Mar 17, 2016 at 12:19 PM
Mar 17, 2016 at 12:19 PM
Hi Kitchens,
Try these formula's:
=AND($P1<>"",$D1="Green")
=AND($P1<>"",$D1="Red")
As shown in the pic below:
Best regards,
Trowa
Try these formula's:
=AND($P1<>"",$D1="Green")
=AND($P1<>"",$D1="Red")
As shown in the pic below:
Best regards,
Trowa
