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".
--
Thanks
Shawn