Hi all.

I am setting up a spreadsheet that tracks window orders. To make it
easy, let's say we have 2 manufacturers. Each manufacturer has a
different set of min/max (for height and width) dimensions for their
windows depending on the style chosen (DH, slider, casement, etc.)

So let's say I have a drop-down menu in A1 to pick which manufacturer
I'm ordering from.

Cell B1 is where I enter the window style (DH, casement, etc from a
drop-down).

I would like cell C1 to be where I enter the width of the window and
C2 to be where I enter the height. Depending on the manufacturer and
window style, I would like to set the parameters of the cell to not
allow dimensions that fall below the minimum or greater than the
maximum.

Thanks in advance for any help on where to start.

I'd start at Debra Dalgleish's site:

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

JNorris wrote:

Hi all.

I am setting up a spreadsheet that tracks window orders. To make it
easy, let's say we have 2 manufacturers. Each manufacturer has a
different set of min/max (for height and width) dimensions for their
windows depending on the style chosen (DH, slider, casement, etc.)

So let's say I have a drop-down menu in A1 to pick which manufacturer
I'm ordering from.

Cell B1 is where I enter the window style (DH, casement, etc from a
drop-down).

I would like cell C1 to be where I enter the width of the window and
C2 to be where I enter the height. Depending on the manufacturer and
window style, I would like to set the parameters of the cell to not
allow dimensions that fall below the minimum or greater than the
maximum.

Thanks in advance for any help on where to start.

--

Dave Peterson