RGBY formula

jgneely72151

Need help…

For the Epex Ready field, I want the ball in the cell to either be red or green. It should only turn green when the 3 fields that proceed it turns green. Any help is greatly appreciated.

bisaacs

Hey @jgneely72151,

You will want to use an IF/AND statement for this:

=IF(AND([EPEX Face Page]@row = "Green", Budget@row = "Green", [Budget Justification]@row = "Green"), "Green", "Red")

Hope this helps!

bisaacs

Hey @jgneely72151,

You will want to use an IF/AND statement for this:

=IF(AND([EPEX Face Page]@row = "Green", Budget@row = "Green", [Budget Justification]@row = "Green"), "Green", "Red")

Hope this helps!

jgneely72151

Thanks so much as I was not using the AND formula and just kept getting an error. This is perfect for what I need it to do! Have a great day!