Updating a Excel calendar based on range values
 

Hi..

I'm trying to show daily activities on a Excel calendar from a range. I
downloaded a template from Microsoft for the calendar aspect, and now looking
at the conditional formatting options available for Excel 2003 (required
version).

http://www.ozgrid.com/VBA/excel-cond...ting-limit.htm

I need to show daily activities for three columns (varied ranges) of dates,
each activity would be a different colored text depending on which column the
activity is representing. The daily activity data would be a different cell
though the same row as the date range.


Any ideas on how to go about doing this are appreciated!!