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 ...
=($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