Conditional formatting to highlight already conditional formatted days

Hello all
I have a calendar that I'm using conditional formatting to highlight my days going to work and days leaving work. The formulas I use for the conditional format are these:

=NOT(ISNA(MATCH(C23,firstworkday,0)))

and

=NOT(ISNA(MATCH(C23,lastworkday,0)))

My question is... Is is possible to use conditional formatting to have the dates between these two formatted cells highlighted?

My calendar is attached. I have office 2003 on this computer and office 2007 on another. Thanks!

I think I'm on the right track.

I created a new sheet with the dates I needed and named that range. My next question is...

Can I have a date start then auto polulate the next 28 cells? Can I have a cell start with any number then make the next cells populate given any number?

Any help would be appreciated. Thanks.

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!