Conditional Formatting Date Range with Unique task colors

I have a list of tasks with date ranges that I want to show on a calendar I created in excel. I want each task to have a unique color and some of these tasks might have overlapping dates.

Task 1 3/14/2012 - 3/17/2012
Task 2 4/21/2012 - 4/22/2012
Task 3 4/20/2012 - 4/27/2012

I had it working when it was set up like a gantt chart and all tasks had the same color, but now that I have compact monthly calendars I cannot get it to work with the same =AND(statement) to color the date ranges in between the user input. Is there a way to assign a conditional formatting color to each task as I enter a new task?


Also, I have the dates listed on another sheet and I input the date as =DAY(A3) to make the calendar look nicer. This does not preserve the date formatting. None of the date cell formatting options have just the single day either. Any ideas on how to keep date formatting with only the day?

Here is an idea of what my calendar looks like, each date is formatted to just show the day of the entire date.
cal.JPG