Dropdown Menu

  • Thread starter Thread starter That's Confidential
  • Start date Start date
T

That's Confidential

In A1, I have a drop down menu with YES or NO as choices. Now, if YES is
selected, I would like the date to automatically appear in B1. If the answer
is NO, then I would like the cell to remain clear.

Any ideas?
 
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Put a formula in B1

=IF(A1="YES",TODAY(),"")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Thanks Bob

Bob Phillips said:
Put a formula in B1

=IF(A1="YES",TODAY(),"")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
Click to expand...
 
Back
Top