| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Stamp
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Stamp
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Stamp
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? Bob Phillips wrote: 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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Stamp
Have you tried replacing the TODAY() with NOW()?
-- HTH Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "japc90" wrote in message ups.com... 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? Bob Phillips wrote: 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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Stamp
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-A120 because that is just wrong! -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "japc90" wrote in message ups.com... 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? Bob Phillips wrote: 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! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Stamp
This works great. The only problem is that it is turning my empty cells
red as well. How do I avoid this? Bob Phillips wrote: 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-A120 because that is just wrong! -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "japc90" wrote in message ups.com... 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? Bob Phillips wrote: 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! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Stamp
Change the formula to
=AND(A1<"",TODAY-A120) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "japc90" wrote in message ups.com... This works great. The only problem is that it is turning my empty cells red as well. How do I avoid this? Bob Phillips wrote: 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-A120 because that is just wrong! -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "japc90" wrote in message ups.com... 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? Bob Phillips wrote: 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! |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Stamp
Thanks. Works perfect.
Bob Phillips wrote: Change the formula to =AND(A1<"",TODAY-A120) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "japc90" wrote in message ups.com... This works great. The only problem is that it is turning my empty cells red as well. How do I avoid this? Bob Phillips wrote: 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-A120 because that is just wrong! -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "japc90" wrote in message ups.com... 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? Bob Phillips wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time and Date stamp - Pivot Chart | Excel Discussion (Misc queries) | |||
| How to display seconds on time stamp? | Excel Worksheet Functions | |||
| How do i automate a static time stamp? | Excel Discussion (Misc queries) | |||
| time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
| Excel Time Manipulation | Excel Discussion (Misc queries) | |||
Linear Mode
