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!
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!