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
Hello, i would like to change the colour of a number of cells in a row if column P contains any text, however the colour it changes to depends on the text in column D would you please be able to help


many thanks.



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
Hi Kitchens,

Try these formula's:
=AND($P1<>"",$D1="Green")
=AND($P1<>"",$D1="Red")

As shown in the pic below:


Best regards,
Trowa
1