Colour changing in rows determined by text in 2 different cells [Solved]

Ask a question kitchens - Latest answer on Mar 17, 2016 12:19PM
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.
See more 
moins plus
Hi Kitchens,

Try these formula's:

As shown in the pic below:

Best regards,
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!