Hello Marjo,

What I need is, the validation in A1 should change respectively when we
drag it till A100.

I have given the formula =IF(B1)=False in the data validation in A1

But when I copy the same validation to A2 the formula should change to
=IF(B2)=False.

Is it possible? Is my question clear?

Thanks for the help.

-Dileep