How to enter dates and then have excel color in those dates

[jgrant78]

Hello everyone,

This is what I am trying to accomplish. I want to be able to enter a date or range of dates ie...3/17/2011 or 3/1/2011-3/17/2011 in a cell and then have those dates change color on a calendar that is on the same sheet or another tab or tabs. Hope I explained myself well enough and thanks for any help in advance becuase I am not very good with this type of stuff.

 

[jgrant78]

O and I have excel 2003..sorry forgot to mention that

 

[jgrant78]

Bump..Please help

 

[jgrant78]

I know there has to be an excel guru that can help me..

 

[jgrant78]

This is my last attempt for help on this subject . Nobody knows how to do this?