Time Stamp

J

japc90

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!
 
B

Bob Phillips

Use conditional formatting with a formula of

=TODAY()-A1>20

and select a pattern colour of red.

--
HTH

Bob Phillips

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

japc90

I got this to work for the date but not the time. Is there a way to get
it to consider time as well. For example, need it to distinguish
between 8:20am and 8:30am. I also had to remove the brackets to get it
to work. What did I do wrong?
 
B

Bob Phillips

Distinguish in what way? My formula tested for the date in A1 being more
than 20 days, how do you wish to incorporate time?

And do you really mean you had to use

=TODAY-A1>20

because that is just wrong!

--
HTH

Bob Phillips

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

japc90

This works great. The only problem is that it is turning my empty cells
red as well. How do I avoid this?
 
B

Bob Phillips

Change the formula to

=AND(A1<>"",TODAY-A1>20)

--
HTH

Bob Phillips

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

japc90

Thanks. Works perfect.

Bob said:
Change the formula to

=AND(A1<>"",TODAY-A1>20)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
Click to expand...
 
Top