Excel calendar

[franchise22]

I would like to take a list from one tab and display that information into a calendar on a second tab as well as highlight those dates using conditional formatting. The tasks will always remain the same, but the dates will be variable.

For example List:

Task Start Date End Date
Task 1 6/14/2010 6/18/2010
Task 2 6/21/2010 6/25/2010

Any help would be appreciated

 

[tusharm]

Maybe something along the lines of
Using a Worksheet for a Gantt Chart - I
http://www.tushar-mehta.com/excel/newsgroups/worksheet_as_chart/worksheet_as_gantt_chart.htm