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