in Conditional formatting, select column e.g. colA and:

Formula is: =AND(A1<today(),A1<"")

select colour

HTH

"awilliams" wrote:

i have having trouble finding a function that will allow me to make the cell
change red if the date that is entered into that cell becomes older than the
current date. if anyone can help me that would be great.
thanks