I have built a scheduling worksheet/shared workbook for my office, There is a
drop down that lists from 1-9 available slots, with cells below coordinating
with those spots. I want to know if i can set the drop down to either block
out the extra cells if say a person were to set us at 2 possible for the day,
then the other 7 cells would be a different color, or blocked off, or
something. Can anyone help with this?
--
NealMed