Room Placement Grid
 

Hi,
I've been trying to chart colors into cells according to if a room
is occupied for a certain period according to the period of stay of a guest.
Below is a snapshot of the worksheet which reperesents room numbers
vertically and the dates horizontally:
Then I have a table where I have the name of the guest, room number and
period of stay.(Arrival Date and Departure Date)
When I open the worksheet I want it to go to the table looking at the period
of stay of the guests and to plot on the worksheet lets say a color which
represents the room which is occupied on those days, along with the name of
the guests.