Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple data validation criteria?
Working in 2003, but this workbook has to also work in 2007
For this project I have to avoid macros because users are remote and may not enable macros. I have a column which needs two different data validation criteria; (1) ColumnA Column B and ColumnA <Column C (I can do this with data validation) (2) ColumnA does not contain values at more than one decimal place 4.2 is ok, 4.21 is not I can also do this with data validation (custom formula) However, Excel appears limited in that I cannot apply more than one data validation criteria. Is there any (non-VBA) workaround, or am hosed? I'm considering the use of conditional formatting, but again this only provides a visual prompt, and does not force the value to meet validation standards, and unlike the data validation, there is no prompt to tell the user why the value is inappropriate. I tried setting up a mirror cell (D1=A1) and set the secondary data validation criteria on D1, but changes in values passed via formula do not appear to trigger the data validation check. Thank you for any suggestions, Keith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if vlookup for multiple criteria for vdata validation | Excel Worksheet Functions | |||
multiple data validation criteria | Excel Discussion (Misc queries) | |||
multiple validation criteria for one cell | Excel Worksheet Functions | |||
Data validation two criteria | Excel Worksheet Functions | |||
Validation - multiple criteria in one cell | Excel Discussion (Misc queries) |