Is there a way to make excel send people alerts

I have an assessment speadsheet going into sharepoint. Is there anyway to send an individual a report or alert when reassessment is due? Some will be annual, some 6 months and some 13 weeks.

Scrap this found a way to set up an alert. Thanks

Hi Carolan

How do you do it

thanks

I would like to know also.

Hi it wasn't me that set this up it was already in place, I'm not back at the office until wednesday so I will find out exactly what was used then..but its not an alert as such from what I have been told its a differant spreadsheet that basically changes colour when something is due a reassment. so say 6 weeks before it will go orange 3 weeks before another colour and a week before it will turn red.

I am presuming a consiquence formula has been used but I am not certain how they have linked all other workbooks up to alert one. If this sounds useful then let me know and I will deffinatly find out Wednesday if I can't get the info before.

^ Sounds like they used conditional format. Also, you can use a macro to issue a popup at certain time if you want a reminder.