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 January 16, 2023 - Mar 17, 2016 at 12:19 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 17, 2016 at 12:19 PM
Related:
- Colour changing in rows determined by text in 2 different cells
- Five nights in anime 2 - Download - Adult games
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Plants vs zombies 2 pc download - Download - Strategy
- Crimping colour code - Guide
- How to change date format in excel - Guide
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
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
