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

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
 
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
 
Back
Top