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
 
apr pillai

apr pillai

Joined
Jul 20, 2011
Messages
16
Reaction score
0
  1. Select the cell where you want to set the only word 'blue'.
  2. Select Data Validation.
  3. Select the Settings Tab.
  4. Select List in the Allow: control.
  5. Remove the Check marks from Ignore-Blank, In-Cell Dropdown.
  6. Type blue in the Source control.
  7. You can Set the Input Message to display a clue and Error Alert to display an error message when a text value other than blue is entered into the cell.
  8. Copy and paste the cell contents into a range if you want to implement this into a range of cells.
 

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
return specific character read from right to left 2
Validation rule for Combo Box 0
Repeating VB script for other cells in same worksheet 1
custom data validation on cells with data validation values 2
Data Validation Formulas 3
Data Validation blanks for formulas 18
Expression to Msgbox 0

Top