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