You need an event sub for that, something like this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "B1" Then
If Target.Value = "No" Then
Range("B2").Validation.Delete
Range("B2").Value = "NA"
Else
Range("B2").Value = ""
Range("B2").Validation.Delete
Range("B2").Validation.Add Type:=xlValidateList,
AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="Yes,No"
Range("B2").Select
End If
End If
End Sub

Regards,
Stefi


€žSuzanne€� ezt Ã*rta:

Good morning. I'd like to have formula in B2 that returns NA if B1 is No, if
B1 is Yes, i'd like to force drop down selection or validation in B2 of
Yes/No - is this possible?

A B
1 Was it cold enough to snow? Yes/No
2 Did it snow? =if(B1="No",NA)

--
Thank you -- Suzanne.