AnsweredAssumed Answered

Conditional Formatting based on number of days

Question asked by Vicky on Aug 22, 2014
Latest reply on Aug 22, 2014 by Vicky

Title

Conditional Formatting based on number of days

Post

     Hi,

     I have a date field called ETD that users will use to enter in the estimated time of departure. My boss wants ETD to change colors, red for when the date is unconfirmed and green after we confirm the date.  He wants ETD to automatically change to red every 10 days to remind him to send an email to confirm.  ETD will change back to green when we either click an ok button or if we change the date.  I understand that we use conditional formatting to change the color of the fields, but I am unsure of what formula to use to keep track of the number of days that have passed.  If there is another way to change the color of the fields please let me know and I'll try it.

     Thanks

      

Outcomes