How would I create a macro that would change dates to the word " present" when that date becomes todays date and then change it to red text? For exxmple: A future date has been added to a list of dates. I want the date to change to the word "present" when that date in "real time" is reached and then color it red that way I can search the list for the word "present" to find the projects that are due.

Hope that makes sense. Thank you for any help that you can provide.