conditional formatting

Occasional Visitor

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

1 Reply

@Chiara13 

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

conditional formatting.JPG

In the example the formatting is applied to this range:   

=$B$1:$B$10