Conditional Color


Hi all!

How do I create a formula if the result is between 1.00-1.10 it will turn green and if all others - it will turn red?

It will have to be added to this current formula because the cell uses it to calculate the average.

=([1st Patient H/L]@row + [2nd Patient H/L]@row + [3rd Patient H/L]@row) / 3

Thank you!!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!