Row Color Change - Based upon formula content


I would like to color an entire row, based upon the result from a date formula. Is that possible? For example, if today's date field is x number of days beyond another date field, I would like to color the entire row a specific color. Thanks for your help.


  • David Joyeuse
    David Joyeuse ✭✭✭✭✭

    Condition formatting does not allow you to using conditions between two or more cells.

    So I would suggest the use of an helper column, preferably a checkbox type. If Date A is x number of days beyond Date B, then check the box.


    Then use conditional formatting based on the checkbox. It'll do the trick.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!