I have searched Contextures.com, Excel help online, and this community and I
am baffled (been staring at this too long). I know the answer is simple, it
just escapes me.

Excel 2007-

I have cell D11 and D12 I want a dropdown of Yes,No; only one cell can have
a Yes answer. Then if D11 is Yes, move user to cell E15, if D12 is Yes, move
user to cell E13. I thought I could do a Data Validation using Custom/Formula.

I appreciate your help. Thank you!
--
Thank you,

scrowley(AT)littleonline.com