Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Drop-down options
I am trying to link multiple cells and can not figure out how to do this
properly. Example: One cell has a drop down menu that has choices of: circles, squares, or rectangles. But the next cell requires a number within a certian range, but this range is different depending on which of the first cell was chosen. circles have to be between 1 and 5 squares have to be between 3 and 9 and rectangles have to be between 17 and 35 I can not figure out how to do this....can anyone help? Thanks, John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
Linking options | Setting up and Configuration of Excel | |||
Modifying drop-down box options and formats | Excel Discussion (Misc queries) | |||
Drop-down menu options | Excel Discussion (Misc queries) | |||
How do I set up a drop down box in Excel with a list of options f. | Excel Discussion (Misc queries) |