How do I do conditional validation in excel?
 

I want to set up a cell with conditional validation. If an answer is (x) then
validation comes from d:2 if answer is (y) then validation comes from d:3.
Can excel do this?

How do I do conditional validation in excel?
 

See Debra Dalgleish's site for some instructions:
http://contextures.com/xlDataVal02.html

Barry wrote:

I want to set up a cell with conditional validation. If an answer is (x) then
validation comes from d:2 if answer is (y) then validation comes from d:3.
Can excel do this?

--

Dave Peterson

How do I do conditional validation in excel?
 

Thanks Dave, I had looked all over that site befor I posted, I just didn't
know what exactly I was looking for. Thanks for pointing me in the right
direction.

"Dave Peterson" wrote:

See Debra Dalgleish's site for some instructions:
http://contextures.com/xlDataVal02.html

Barry wrote:

I want to set up a cell with conditional validation. If an answer is (x) then
validation comes from d:2 if answer is (y) then validation comes from d:3.
Can excel do this?

--

Dave Peterson