Prev Previous Post   Next Post Next
  #1   Report Post  
Shawn
 
Posts: n/a
Default Validation

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation Mike R Excel Discussion (Misc queries) 11 May 6th 05 02:38 AM
Data Validation gbeard Excel Worksheet Functions 1 May 3rd 05 09:09 AM
data validation gbeard Excel Worksheet Functions 2 May 2nd 05 09:57 PM
Effect of Conditional Formatting, Data Validation Bill Sturdevant Excel Discussion (Misc queries) 1 January 25th 05 11:50 PM
Data Validation Window? Ken Excel Discussion (Misc queries) 1 January 11th 05 10:48 PM


All times are GMT +1. The time now is 04:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"