Here is an example (not mine and not successful decision) http://dl.dropbox.com/u/28294425/advanced_calendar.xls
I looked for in the Internet a good calendar on conditions:
1 . it is possible to tie to certain sheets and ranges (that is at a choice of a certain cell on a sheet there is a calendar, thus it is possible to specify - on what sheets and in what columns it has to work);
2 . it is possible to add notes by dates;
3 . If in a cell there is a date for which there are events (note) - it is highlighted.
Perhaps, someone has a similar decision and someone is ready to share?
I looked for in the Internet a good calendar on conditions:
1 . it is possible to tie to certain sheets and ranges (that is at a choice of a certain cell on a sheet there is a calendar, thus it is possible to specify - on what sheets and in what columns it has to work);
2 . it is possible to add notes by dates;
3 . If in a cell there is a date for which there are events (note) - it is highlighted.
Perhaps, someone has a similar decision and someone is ready to share?