Use conditional formatting with a formula of

=TODAY()-A120

and select a pattern colour of red.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"japc90" wrote in message
oups.com...
I want to create a column where the user enters a date and time.I that
exceeds a certain number of days when compared to the current date and
time it will turn the cell red. Is this possible?

Thank you!