| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down to Fill Cells
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a drop down list that will fill in mutilple cells.... | Excel Discussion (Misc queries) | |||
| HOW DO I SET UP DROP DOWN CELLS TO AUTO FILL AS I START TYPING IN. | Excel Discussion (Misc queries) | |||
| Auto Fill Cells, When Choosing From Drop-Down List... | Excel Worksheet Functions | |||
| Creating an auto fill or drop down | Excel Discussion (Misc queries) | |||
| create a fill in template to tab to fill in cells | Excel Discussion (Misc queries) | |||
Threaded Mode
