room schedule

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I would like to put together a shared workbook to use as a room
schedule. I want to have a grid with times on the left and room numbers at
the top. I would put in the rooms that are automatically block for the person
and when they have scheduled a patient (by placing the patient's initials) I
want the block to change color. I could do a conditional format to change
from blank to orange when the cell is no longer blank... but could I 'layer'
it so that one layer could have the standard schedule and the 2nd layer could
be what people have scheduled? Maybe there is a template out there?
 
Jenn, I think your best bet would be to use Visio, in which you can
determine your layers and vary the colour transparency to illustrate your
schedule.

Gilles
 
Back
Top