If/Or formula wit a Checkbox.

JFrye · 04/11/19

I need to color a ball yellow if the value in a column is between .05 and .15. If the value in the same column is greater than .15 OR a checkbox is selected, I need the ball to be red. Not sure how to accomplish this. Appreciate your help.

Nic Larsen · 04/11/19

Try:

=IF(OR([Check Box]@row = 1, [Value Column]@row > 0.15), "Red", IF(AND([Value Column]@row >= 0.05, [Value Column]@row <= 0.15), "Yellow", "Green"))

If/Or formula wit a Checkbox.

Comments

Help Article Resources

Categories