How to change font color depending results


I created test with Smartsheet formula. I got a column for the result. I would like to know how to write my formula in that column for the font to change color.

For example, everything equal or higher than 60% is green 59% or less is red.


Best Answer

  • Amber Eakin
    Amber Eakin ✭✭✭✭✭✭
    edited 01/28/22 Answer ✓

    Hello, @Indianaduck ! You want Conditional Formatting rather than a formula for this task. Using your example, below is a screenshot of how your conditional formatting rules would be set.

    This screenshot shows the outcome of this conditional formatting.

    I hope this helps!


    Amber Eakin, MSLS, M.Ed.

    Adult Education Specialist | Process Improvement Enthusiast


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!