Dec 06 2022 10:53 AM
Hello,
I'm trying to change the colour of a cell depending on the text of 2 different cells
e.g.
if cell A1="completed" and cell B1="yes" then colour the cell B1 green
if cell A1="completed" and cell B1="no" then colour the cell B1 red.
thank you in advance
Dec 06 2022 10:59 AM
=($A1="completed")*($B1="yes")
This is the rule for conditional formatting for green.
=($A1="completed")*($B1="no")
This is the rule for conditional formatting for red.
In the example the formatting is applied to this range:
=$B$1:$B$10