|
|
#1
12-26-2018, 01:41 AM
|
|||
|
|||
Question of data Validation
Hello
Have a look at the file attached. I used 'Data Validation' to force cell B1 to accept just numbers 1 or 2 (if A1 be equal to the word "Iamgood"). If the word "Iamgood" (in cell A1) changes to "I am good", then it does not work. It seems spaced between characters make problem for it? Let me know your ideas. Thanks a lot. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Data Validation - List
|
Webbn111 | Excel | 9 | 03-09-2016 04:30 PM |
| Paste over data validation | saurabhlotankar | Excel Programming | 2 | 05-24-2015 11:52 PM |
|
data validation from another sheet
|
paulys | Excel | 1 | 06-30-2014 01:40 AM |
|
Data Validation drop down
|
rkalapura | Excel | 1 | 05-27-2012 02:23 AM |
| Data validation with IF | Klyxrastafari | Excel | 1 | 10-03-2011 04:41 PM |
Windows 8 
Office 2013
Threaded Mode