Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Room Grid Placement | Charts and Charting in Excel | |||
Excel 2007 - "Snap To Grid" doesn't work on same grid line | Excel Discussion (Misc queries) | |||
Grid lines in Excel not showing.Have tools,options,view/grid cked | Excel Discussion (Misc queries) | |||
I need to convert grid.doc to an Excel Grid. | Charts and Charting in Excel | |||
Chat Room | New Users to Excel |