conditional list boxes

[a.cunje]

Hello,

I am trying figure out a way to make a series of list boxes
conditional.

for example:

Cell a1: list box
not started, started

Cell b1: a percentage
can be any number 0-100

Cell c1: list box
please select, ready for review, review complete

cell d1: list box
please select, comments left, no comments, comments cleared

cell e1: list box
please select, ready for review, review complete

what i would like to do is the following:
- cell c1 can not be made ready for review or review complete until
the percentage in b1 = 100
- cell e1 can not be made ready for review unless d1 = comments
cleared

(these types of conditions)

once i figure out how to go about doing this i can code all of the
nitty gritty checks for the rest of them...im just lost as to how to /
where to start....

Thanks,
Andrew

 

[Fred]

Hi Andrew, not sure if this is what you are looking for ..

Assume you will put your lookup criteria on a sheet called Sheet2

lets say you enter "Not Started" into Cell A1 on Sheet2 then "Started" into
Cell A2 Sheet2

Wipe over these two cells and in the box to the left of the formula bar
enter a name for the range you have just selected lets say you name the
range MyList1, ...... hit enter to save name

Now go to Sheet1 and select cell A1.
From the menu Bar choose Data > Validation
You will now see a form where you will be able to select from a dropdown
list... from this list choose "List"

You can now enter a source for your list type in =MyList1
Click OK and when you choose cell A1 on your Sheet1 you will see a dropdown
list with the options you set up in your named range on Sheet2

you can now do similar for your other criteria selecting different ranges
and different names .

Hope this can get you started.

Fred

 

[a.cunje]

Hello,

Let me try to simplify this a bit.

i dont want someone to be able to select ready for review from the
list in cell c1 unless b1 = 100

from this i should be able to figure out the rest...i hope

~Andrew