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.
There is the worksheet which reperesents room numbers
vertically and the dates horizontally:

A B C D E
F G
1 Date 4-5-08 5-5-08 6-5-08
7-5-08 8-5-08 etc
2 Room No
3 101
4 102
5 103
etc

Then I have a table where I have the name of the guest, room number and
period of stay.(Arrival Date and Departure Date)

Room No. Name Arrival Date
Departure Date
101 Smith 4-5-08
7-5-08
103 Jones 6-5-08
8-5-08



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.
A B C D E
F G
1 Date 4-5-08 5-5-08 6-5-08
7-5-08 8-5-08etc
2 Room No
3 101 Smith Smith Smith
Smith
4 102
5 103
Jones Jones Jones
etc

Of the above it would be simpler on the cells to represent a color lets say
from C3 to F3 with the name in the first cell C3.

Any help would be appreciated.
Thanks
Ange