Data validation for specific text, for example "blue"?

V

vivianb

Joined
Jul 7, 2011
Messages
2
Reaction score
0
I want to allow users to enter only the word "blue" into a cell, if not I want a warning message.
I tried to do it with custom data validation and then with the formula =ISTEXT("blue") but nothing happens. What can i do??? Any Suggestion. Thanks
 
B

BDeitrick

Joined
Jul 19, 2011
Messages
20
Reaction score
0
You can use the List style DV, with just blue as the list. You can also use the in-cell dropdown with that setting.

If you were going to use a custom function, it would be
=CellAddress = "Blue"
like
=A3="Blue"
The formula needs to return TRUE or FALSE - ISTEXT("Blue") always returns TRUE, so no validation is taking place.

Bernie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data validation for specific text, for example "blue"? 1
custom data validation on cells with data validation values 2
Data Validation Formulas 3
Multiple data validation criteria? 1
Data Validation 2
Locking Cell through Validation 3
Data Validation for dates 5
Data Validation Question 1

Top