Validation list and a desired response for No

[leigh_ashlin]

Hi I have a validation list in cell D2 with "Yes" & "No" as the options.

In cell E2, If D2 = No, I want the cell to automatically say "You can't do that"

Can somebody please help with this one?

 

[P Sitaram]

IF(D2="No", "You can't do that","")