| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up a conditional cell from a drop down list in Excel
I'm working on creating an Expense Form in Excel for the employees in my
company. In cell A7 I have a drop down list consisting of: mileage, conference, school, seminar, meetings. The following columns or cells of C,D,E,F,G,H,I - I would like to be conditioned upon the response of the drop down list. If "mileage" is chosen, is it possible that cells G7,H7, and I7 will gray out and cells C7,D7,E7 and F7 will highlight themselves to be filled in by the employee. - ?? Any help would be great!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to Create a Conditional Drop down list | Excel Worksheet Functions | |||
| Creating a drop down list to change decimal value in another cell | Excel Worksheet Functions | |||
| How do I make a drop down list to pick from for a cell in Excel | Excel Discussion (Misc queries) | |||
| How do I create a combo drop down list in Excel? | Excel Worksheet Functions | |||
| Excel: how to formulate conditional cell references | Excel Worksheet Functions | |||
Threaded Mode
