Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
event warning
I'm looking for a way to track upcoming events and have themwarn when they
get within 3 days of the event, maybe change color or something. Or would this be done in another office program? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
event warning
hi
excel will do that. read up on conditional formating. to change color with 3 days waring will look something llike this... cell value is......less than or equal to........=now()+3 regards FSt1 "Andrew" wrote: I'm looking for a way to track upcoming events and have themwarn when they get within 3 days of the event, maybe change color or something. Or would this be done in another office program? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
event warning
Outlook has a very good calendar that enables reminders by date and time.
However, if you need to see them laid out in a spreadsheet, try a Gantt Chart using conditional formatting. The planning chart on the following website should give you all you need to do this. http://www.erlandsendata.no/english/...downloadcharts Use VBA to update your date (E3 in the example) when the WB opens and you immediately get a chart of what tasks are due and when . -- Steve "Andrew" wrote in message ... I'm looking for a way to track upcoming events and have themwarn when they get within 3 days of the event, maybe change color or something. Or would this be done in another office program? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
event vba | Excel Worksheet Functions | |||
VBA Event | Excel Discussion (Misc queries) | |||
event | Excel Discussion (Misc queries) | |||
Pop up warning | Excel Discussion (Misc queries) | |||
Warning!!! | Excel Worksheet Functions |