Hi Dileep,

After you set the validation on A1, select A1 to A100 and click
Data-Validation again. Excel will ask you if you want to extend the
validation on A1 to the other cells.

Cheers
Marjo


"Dileep Chandran" wrote:

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