Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up excel to let me know when a date has expired?
I am trying to set up excel where it will notify me when a perticular date
that I have entered has expired. Such as an insurance policy which is going to expire at a set time. I believe you can set this up in Excel where excel will change the color of the cell to reflect this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up excel to let me know when a date has expired?
"UB" wrote: I am trying to set up excel where it will notify me when a perticular date that I have entered has expired. Such as an insurance policy which is going to expire at a set time. I believe you can set this up in Excel where excel will change the color of the cell to reflect this. You have two options, conditional formatting or create another column and use an if statement Depending on the version of Excel you're running, will determine how you implement the conditional formatting, 2007 has a built-in date conditional formatting, previous versions would require you to 'calculate' it. HTH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXPIRED or DATE | Excel Discussion (Misc queries) | |||
Can Excel automatically change the font color of an expired date? | Excel Worksheet Functions | |||
excel today countif over expired date | Excel Worksheet Functions | |||
Expired date to show up automatically | Excel Discussion (Misc queries) | |||
Expired Date Formula | Excel Worksheet Functions |