| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
data validation for a single text entry
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
data validation for a single text entry
Hi,
I assume I enter the word Yes in cell B1 then position in the cell you want to apply data validation, go to data validation, custom and enter there the formula as follow =OR(A1=B1,A1="") the above formula is validating data entered in A1 "MZ" wrote: 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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
data validation for a single text entry
Assuming your input cell is F10, In the data validation box -- choose Custom
and in the formula box put: =OR(ISBLANK(F10)=TRUE,F10="Yes") -- hope to help, cm "MZ" wrote: 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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
data validation for a single text entry
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
data validation for a single text entry
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 . |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
data validation for a single text entry
I tried your suggestions and typed: =AF="Yes"
(AF is the cell address) Ok, so what's the row number of the cell address? Is it AF10? AF25? You need to include the row number. -- Biff Microsoft Excel MVP "MZ" wrote in message ... 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 . |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
data validation for a single text entry
Thank you for correcting my error in identifying the cell; it works fine now
-- MZ "T. Valko" wrote: I tried your suggestions and typed: =AF="Yes" (AF is the cell address) Ok, so what's the row number of the cell address? Is it AF10? AF25? You need to include the row number. -- Biff Microsoft Excel MVP "MZ" wrote in message ... 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 . . |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
data validation for a single text entry
Good deal. Thanks for the feedback!
-- Biff Microsoft Excel MVP "MZ" wrote in message ... Thank you for correcting my error in identifying the cell; it works fine now -- MZ "T. Valko" wrote: I tried your suggestions and typed: =AF="Yes" (AF is the cell address) Ok, so what's the row number of the cell address? Is it AF10? AF25? You need to include the row number. -- Biff Microsoft Excel MVP "MZ" wrote in message ... 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 . . |
|
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
data validation for a single text entry
Another option is to select Allow: List
In the Source box, type: Yes Remove the check mark from the box for In-cell drop down Note: Entries will have to exactly match what you type in the Source box, so YES or yes would not be allowed, only Yes If you want to allow other variations, you could add them in the Source Box, e.g.: Yes,YES,yes MZ wrote: 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 -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
| Single Point Data Entry Worksheet? | Excel Discussion (Misc queries) | |||
| Formula and Data Entry in a Single Cell | Excel Discussion (Misc queries) | |||
| Return a block of text based on a single "short name" entry | Excel Worksheet Functions | |||
| How to automatically change a single letter text entry to caps?? | New Users to Excel | |||
Hybrid Mode
