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?