Home |
Search |
Today's Posts |
#1
|
|||
|
|||
validation
I want to add validation to a cell based on what is selected from a drop down
in another cell. eg. If apple is selected excel will take validation from one area if orange is selected excel will take validation from another list. I hope this is clear. |
#2
|
|||
|
|||
Hi!
Sounds like you want dependent dropdown lists. Instructions can be found he http://contextures.com/xlDataVal02.html Biff -----Original Message----- I want to add validation to a cell based on what is selected from a drop down in another cell. eg. If apple is selected excel will take validation from one area if orange is selected excel will take validation from another list. I hope this is clear. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional data validation (using a filtered range?) | Excel Worksheet Functions | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
Validation List and VLookup are ackting strange | Excel Worksheet Functions | |||
Data Validation Window? | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |