Stumped Conditional Formatting or Validation?
 

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

Stumped Conditional Formatting or Validation?
 

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"SCrowley" wrote in message
...
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

Stumped Conditional Formatting or Validation?
 

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


"Bernard Liengme" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"SCrowley" wrote in message
...
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

Stumped Conditional Formatting or Validation?
 

One way:

Put the dropdown in D11 only. In D12 enter

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

In article ,
SCrowley wrote:

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

Stumped Conditional Formatting or Validation?
 

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

scrowley(AT)littleonline.com


"JE McGimpsey" wrote:

One way:

Put the dropdown in D11 only. In D12 enter

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

In article ,
SCrowley wrote:

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