Try...

=(C9="Yes")+(C9="No")

Hope this helps!

In article ,
"Shawn" wrote:

I have this formula in a data valadation: =C9=Yes

This won't allow any entry into this cell but "Yes".

I would like a formula that would allow a "Yes" or a "No".