Thread: Stumped Conditional Formatting or Validation?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default 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?
Reply With QuoteReply With Quote