http://www.contextures.com/xlDataVal02.html
It might give you the required information

"jp_az" wrote:

I reviewed the answers from the post by Shavey on 7/3/06 but still is not
working for me.

I am creating a form for other users and based upon their answers to prior
questions need a list available for answeres to other questions. The
formulas in the form used a suer defined validation (Y, N, N/A) previously,
but I need the same list/validation to be available only if other conditions
apply. For example:

If the response to a prior question is Y, then I want the cell to return
N/A, If no, then I need the user to chose from Y, N or N/A.

So if A1 = Y then B1 = N/A

If A1 = N then B1 = select from list of Y, N or N/A

Any way to do this? Any help is appreciated!