Data Validation: Prevent Cell Input If Condition Exists

Z

Zack S.

Hello: I have an Excel model where there are two columns, A & B. I
need a validation rule that prevents entries into the B column if a
condition in A is present.

For example in cell B1 I would have the data validation rule formula
be:
=IF(A1="Ford",[PreventEntry],[AllowAnyEntry])

1) Any ideas on how I could accomplish this validation using Excel's
Validation tool?

2) Any ideas using VBA?

Thanks!
 
B

Bob Phillips

DV with a formula of

=NOT(ISNUMBER(MATCH("Ford",A:A,0)))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top