Forum Discussion
conditional formatting
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
=($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
