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!

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)



"Zack S." <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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!
>