How to have a date change to a red background


I have 2 columns: one is an expected ship date and the other is current ship date. I want a red background to change automatically if the ship date is later. What is the best way to go about this?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!