Creating RYG based on differences between two percentage columns


I have a percentage planned and a percentage complete column in a project sheet and want to acheive the below:

Highlight Red ball when % complete is more than 5% below % planned.

Highlight Yellow ball when % complete is between 5 & 1% below % planned.

Highlight Green ball when % complete is >= % planned.

Appreciate any guidance!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!