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

vivianb · vivianb's Computer Specifications

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's Computer Specifications

Select the cell where you want to set the only word 'blue'.
Select Data Validation.
Select the Settings Tab.
Select List in the Allow: control.
Remove the Check marks from Ignore-Blank, In-Cell Dropdown.
Type blue in the Source control.
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.
Copy and paste the cell contents into a range if you want to implement this into a range of cells.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data validation for specific text, for example "blue"?	vivianb	Microsoft Excel Worksheet Functions	1	19th Jul 2011 05:55 PM
Validation ?:Accepting both Numbers AND specific letters("N","n","	Antonio	Microsoft Excel Misc	2	22nd Apr 2008 05:07 PM
Data Validation: Allow "List" or "Whole number"	=?Utf-8?B?bW9uaXI=?=	Microsoft Excel Programming	1	31st May 2006 04:40 PM
Data Validation: Allow "List" or "Whole number"	=?Utf-8?B?bW9uaXI=?=	Microsoft Excel Programming	0	31st May 2006 03:49 PM
Re: Hard drive <font color="blue"><B>data</B></font&g t; <font color="blue"><B>recovery</B></fo nt> services?	halleyscomet@gmail.com	Storage Devices	0	7th Dec 2004 03:11 PM