| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation when a list is already in place
I want to be able to allow an option on a drop down list only if another cell
has a particular value. What I am trying to do is I have a list of people with their title (Mr,Ms,Mrs,Miss) and I also have Gender (Male,Female). Both of these a dropdown lists. I would like when Ms,Mrs or Miss is selected, it only allows an entry of Female to gender, and if Mr is selected it only allows Male for Gender. Is there any way to do this? Cheers |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Threaded Mode
