Forum Discussion

Chiara13's avatar
Chiara13
Copper Contributor
Dec 06, 2022

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

Excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Dec 06, 2022

    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.

    In the example the formatting is applied to this range:   

    =$B$1:$B$10