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. |
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 |
All times are GMT +1. The time now is 11:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com