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
- Tentacle locker 2 - Download - Adult games
- Five nights in anime 2 - Download - Adult games
- Euro truck simulator 2 download free full version pc - Download - Simulation
- Plants vs zombies 2 pc download - Download - Strategy
- Crimping colour code - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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
