Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation in a Custom setting and forcing Upper Case
Hi All
Just wondering if i want to apply data validation to a cell in a spreadsheet but I want to use a drop down list. I have added a custom validation, used the Upper function and can reference only 1 cell from the sheet, if I want to reference multiple cells I have to use the exact function as this can then cope with the OR operator for the other cell entries in the list whereas the upper function won't allow the use of OR and therefore I can only reference the one cell. All ideas would be welcome. Thanks Ailish |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need character for custom format to force upper case! | Excel Discussion (Misc queries) | |||
change data of entire column from small case to upper case | Excel Worksheet Functions | |||
Forcing Cell Entries to be Upper Case | Excel Worksheet Functions | |||
Changing file in all upper case to upper and lower case | Excel Discussion (Misc queries) | |||
Change case setting from lower to upper with current complete doc | Excel Worksheet Functions |