Making a date go red, if date passes todays date.

[Jamie]

I want to be able to enter a future date that would be black when entered,
and then go red when that date passes. (to show urgent/out of date work).

Is this possible?

 

[David Biddulph]

Yes. Look up "conditional formatting" in Excel help.

 

[Bob Phillips]

Use conditional formatting with a formula of =A1<TODAY()