Thank you T. Valko,
I tried your suggestions and typed: =AF="Yes" (AF is the cell address)
but received a pop-up error in the Validation box that states: A named range
you specified cannot be found
--
MZ


"T. Valko" wrote:

Assume you want to allow only the entry Yes in cell A1 (or leave it empty).

Select cell A1
Goto the menu DataValidation
Allow: Custom
Formula: =A1="yes"
OK

--
Biff
Microsoft Excel MVP


"MZ" wrote in message
...
How can I create a data validation for a single text entry (i.e. to allow
leaving the cell blank or entering the word "Yes") without having to
create a
list of the single entry (i.e. Yes). The other options in data validation
related to numbers, not text.
Thank you
--
MZ


.