| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you create a list & data validation in same cell?
I have a range of 7 cells in a column. I want to be able to
a-allow only a "True" input (from a drop down list unless there is another way to accomplish this) b-if any of the other cells already contain "True", they can not duplicate the entry in the other cells and display an error message that says they can answer "True" only once in the range of cells. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Color cell validation? | Excel Discussion (Misc queries) | |||
| Dependent List (via Data Validation) Error | Excel Worksheet Functions | |||
| Data Validation and Blanks in List | Excel Worksheet Functions | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
