Stumped Conditional Formatting or Validation?

[Guest]

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!

 

[Bernard Liengme]

Nothing can move the users to another cell other than a VBA macro
If you are ready for this; post your Q in the programming newsgroup
best wishes

 

[Guest]

Thank you, Bernard.

What if just cell D11 and D12 have a dropdown of Yes,No; only one cell can
have
a Yes answer?
--
Thank you,

scrowley(AT)littleonline.com

Nothing can move the users to another cell other than a VBA macro
If you are ready for this; post your Q in the programming newsgroup
best wishes

 

[JE McGimpsey]

One way:

Put the dropdown in D11 only. In D12 enter

=IF(D11="Yes","No","Yes")

 

[Guest]

So simple and exactly what I need. Thank you, JE McGimpsey!