Changing Stoplight Color To Red When Date In Due Date Column Passes

I am trying to format the spotlight colors in the Health column. Each row has a Due Date field that contains a date where, once that date comes up, the color in the Health column needs to automatically change from green to red.

How do I go about formulating this?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!