Conditional Formatting based on number of days
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.