I have created a calendar using the DAY function to just return the DAY of
another cell in 01/05/07 format. I want to be able to enter a date in
01/05/07 format in a cell outside of the calendar and have all the days prior
highlighted.

I tried using the Condiotional Formatting in the Format menu, but I can't
seem to figure it out. Am I on the right track, or is there a better way?

Please help,

Joel