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

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

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