Help IF/AND formula with RYG conditional formatting

Adrienne Buesa

How do you create RYG symbol formula that requires multiple conditions of multiple reference cells?

Here are the conditions I'm trying to write a RYG formula for....using reference cells [LEADER NAME] and [RISK FLAG]:

If [LEADER NAME] = BLANK, then keep cell empty

If [LEADER NAME] = NOT BLANK, AND [RISK FLAG] = CHECKED, then “Red”

If [LEADER NAME] = NOT BLANK, AND [RISK FLAG] = UNCHECKED, then “Green”

Advice on how to write this formula? Seems like an IF + AND statement?

Paul Newcome

Try something like this...

=IF([LEADER NAME]@row = "", "", IF([RISK FLAG]@row = 1, "Red", "Green"))

EDIT: Corrected a typo in formula.

Paul Newcome

Try something like this...

=IF([LEADER NAME]@row = "", "", IF([RISK FLAG]@row = 1, "Red", "Green"))

EDIT: Corrected a typo in formula.

Adrienne Buesa

Thank you this worked perfectly!

Paul Newcome

Happy to help! 👍️