You could use a =if(countif(sheet2!$B$1:$B$100,"=B1") 0,,) as the
conditional formating

Your calendar could contain the actual dates
A B C

1 3/1/07 3/3/07 3/4/07

2 3/8/07 3/9/07 3/10/07

3 3/15/07 3/16/07 3/17/07

"joannelj" wrote:

I think I see how conditional formatting works - but how do I link the dates?
I think I may have been unclear. Instead of saying people are checking out
equipment, let me say they are reserving equipment. ie Chantel wants to
reserve 4 mannequins on 6/23/07. How do I take that, and have it show up on
the calendar sheet, that 4 mannequins are reserved, and x are left available?

Thanks,
joAnne


"Joel" wrote:

Conditional formating may help. You can use a fomula that checks total items
checked out on sheet 2. If the total is not zero highlight the calendar in
red indicating items are still checked out. Set the color green is the total
is zero.