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!

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!

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!