How to change font color depending results

Indianaduck

Hi,

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.

Thanks

Amber Eakin

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

Amber Eakin

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

Indianaduck

Thanks

It's saving my life!!

Amber Eakin

@Indianaduck I'm glad it's working for you!