Hi,

I have given a data validation for A1. The column is validated to
accept the data only if B1 is true.

The issue is, when i drag down the validation from A1 till A100, the
validation is not changing respectively.

The validation in A2 should accept data only if B2 is true and not when
B1 is true.

It wont change like formulas, when we copy and paste the validation to
next cell?

Any help is greatly appreciated.

-Dileep