| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation Feature
I'm trying to use the validation feature, is it possible to set it up so it
will allow for text strings of 9 and the word "Pending"? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validation Feature
Use the custom setting, with the formula
=OR(LEN(A1)=9,A1="Pending") Select all your cells, and then substitute the Upper-Left cell Address for the A1 in this formula when entering it in the validation dialog. HTH, Bernie MS Excel MVP "Validation Feature" <Validation wrote in message ... I'm trying to use the validation feature, is it possible to set it up so it will allow for text strings of 9 and the word "Pending"? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation with hyperlinks | Excel Worksheet Functions | |||
| How to feed dynamic information to a drop down List (Validation Feature)? | Excel Worksheet Functions | |||
| Copy workbook- Validation function | Excel Worksheet Functions | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| Data Validation Window? | Excel Discussion (Misc queries) | |||
Hybrid Mode
