| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Drop Down boxes
I am hoping one of you can help me.
I have a few drop down boxes Cell B7 - choose option 1 or choose option 2 Cell C9 - If in cell B7 they choose option 2 then the block size must be greater than 10,000 (the drop down includes blocks of sizes down to 250) but I only want it to show it starting at 10,000 if option 2 in Cell B7 is chosen. Is this possible? Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Drop Down boxes
Check out Debra's article on creating dynamic validation:
http://www.contextures.com/xldataval02.html -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Heather" wrote: I am hoping one of you can help me. I have a few drop down boxes Cell B7 - choose option 1 or choose option 2 Cell C9 - If in cell B7 they choose option 2 then the block size must be greater than 10,000 (the drop down includes blocks of sizes down to 250) but I only want it to show it starting at 10,000 if option 2 in Cell B7 is chosen. Is this possible? Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Drop Down boxes
I'll give it a try, thank you! :)
"Heather" wrote: I am hoping one of you can help me. I have a few drop down boxes Cell B7 - choose option 1 or choose option 2 Cell C9 - If in cell B7 they choose option 2 then the block size must be greater than 10,000 (the drop down includes blocks of sizes down to 250) but I only want it to show it starting at 10,000 if option 2 in Cell B7 is chosen. Is this possible? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop-down boxes | New Users to Excel | |||
| Conditional Formulas & Drop Down Boxes | Excel Discussion (Misc queries) | |||
| Drop down boxes/tick boxes | Excel Worksheet Functions | |||
| Conditional Drop Down Boxes | Excel Discussion (Misc queries) | |||
| Drop down boxes.. | Excel Discussion (Misc queries) | |||
Hybrid Mode
