Conditional Drop Down boxes

[Heather]

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!

 

[Luke M]

Check out Debra's article on creating dynamic validation:

http://www.contextures.com/xldataval02.html

 

[confused]

I'll give it a try, thank you!