Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up Alerts and Notification on Excel?
I'd like to set up a Date Tracker for Permits and License that have future
expiration dates. I would like to load all their information onto excel and forget about them. But I would like to be notified or alerted 2-3 month prior to their expiration dates? Is there anyway of doing this? If not on excel, is there a program out there? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up Alerts and Notification on Excel?
Hello,
One approach is to use conditional formatting (using formulas instead of values) such that all expiration dates approaching within your 2-3 month range are color-coded in some way. There is a good article here on the subject: http://www.cpearson.com/excel/cformatting.htm Colby Africa http://colbyafrica.blogspot.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I stop Excel from displaying alerts? | Charts and Charting in Excel | |||
Setting up alerts/reminders in Excel | Excel Discussion (Misc queries) | |||
Settings for pop up alerts in excel | Excel Discussion (Misc queries) | |||
how do i set up sound alerts on excel? | Excel Discussion (Misc queries) | |||
Suppress protection alerts in Excel | Excel Discussion (Misc queries) |