Thread: event warning
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
AltaEgo AltaEgo is offline
external usenet poster
 
Posts: 245
Default 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?