Colour changing in rows determined by text in 2 different cells
Solved/Closed
kitchens
-
17 Mar 2016 à 12:01
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 17 Mar 2016 à 12:19
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 17 Mar 2016 à 12:19
Related:
- Colour changing in rows determined by text in 2 different cells
- Tentacle locker 2 - Download - Adult games
- My cute roommate 2 - Download - Adult games
- Five nights in anime 2 - Download - Adult games
- Saints row 2 cheats - Guide
- How to change text colour html - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
17 Mar 2016 à 12:19
17 Mar 2016 à 12:19
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
