Color code the cells

Lahcene ✭✭
edited 11/27/23 in Formulas and Functions

Hi All,

I have a question regarding color coding the cells on Smartsheet.

How can I color code column (Actual Delivery date) to highlight the following:

Dark green : for when the Actual date is equale or less than Date committed

Light Green : for when the Actual Date is after the date committed

Red : for when Actual date is empty

Many thanks :)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!