Data Validation: Prevent Cell Input If Condition Exists

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zack S. - 23 Feb 2007 19:20 GMT

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!

Reply to this Message

Bob Phillips - 23 Feb 2007 20:08 GMT

DV with a formula of

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

Signature

---
HTH

Bob

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

> 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
[quoted text clipped - 10 lines]
>
> Thanks!

Reply to this Message