Conditional Formatting


I have a sheet where the user would like to have rows highlighted in Red, Amber, Green based on when the last review date was completed:

Review in the last 10 months - Green

Review in last 11 months - Amber

Review in last 12 months (or more) - Red

I'm unsure the best way of doing this - do I need a formula in a helper column that I can look my conditional formatting rule up to, do I do a report that groups by months?

Any ideas greatly received on the best way to achieve getting this information.

Many thanks



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!