Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation problem
Can anyone help me on this one? I have set my data validation (List) using a conditional statement as follows =IF(AND(C3<"",D3="",E3=""),OK,N_A) where OK and N_A are named ranges. The problem I have is that the user can enter any value without getting an error message. Why is this and, more importantly, can it be made to restrict the values to the ones that appear in the drop down lists. Using Excel 2003 and XP Pro TIA Ed -- EdMac ------------------------------------------------------------------------ EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736 View this thread: http://www.excelforum.com/showthread...hreadid=573676 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation problem
Uncheck the Ignore Blank checkbox.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "EdMac" wrote in message ... Can anyone help me on this one? I have set my data validation (List) using a conditional statement as follows =IF(AND(C3<"",D3="",E3=""),OK,N_A) where OK and N_A are named ranges. The problem I have is that the user can enter any value without getting an error message. Why is this and, more importantly, can it be made to restrict the values to the ones that appear in the drop down lists. Using Excel 2003 and XP Pro TIA Ed -- EdMac ------------------------------------------------------------------------ EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736 View this thread: http://www.excelforum.com/showthread...hreadid=573676 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation problem
Thanks Bob Ed -- EdMac ------------------------------------------------------------------------ EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736 View this thread: http://www.excelforum.com/showthread...hreadid=573688 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation with hyperlinks | Excel Worksheet Functions | |||
Data validation problem | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) |