Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Compare two dates and apply conditional formatting

Faith Glass-Wilson
Faith Glass-Wilson ✭✭✭✭
edited 12/09/19 in Archived 2017 Posts

I have two columns of forecasted dates UTILITY and IN SERVICE. When the UTILITY date is past the IN SERVICE date I want both cells hilighted. For example if UTILITY = 9/30/17 and IN SERVICE = 5/10/17, I want both cells to be red.


I understand That I'll have to use a third column to base the formatting from but I cannot get the formula to work out correctly.  All suggestions will be greatly appreciated.





This discussion has been closed.