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.

"joannelj" wrote:

I'm trying to set up a spreadsheet that tracks equipment being checked out,
and how much is left on a given day. I was planning to do a sheet with a
calendar - months across the top, dates 1-31 down the side. On the second
sheet, I have a info about who is checking out what on what date. I thought
I could reference the date on this list, and have it show up in the proper
cell on the calendar page. The person in charge of the equipment would just
enter the info about when stuff is being checked out, and then could look at
the calendar to see which dates still have equipment available. I don't know
how to do this - use julian dates? I have barely begun this project, so if
anyone knows of a better layout idea, I"m open to that, too.

Thanks,
joAnne