Report

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

Ask a question kitchens - Last answered on Mar 17, 2016 at 12:19 PM by TrowaD
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.



Helpful
+1
plus moins
Hi Kitchens,

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

As shown in the pic below:


Best regards,
Trowa
Was this answer helpful?  

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!