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