Hi all,

I want to limit the input order using custom validation. My case is as
following:

From a1 to a10, i want user input one by one in order, so I use custom
validation and my formula is =a1<"" . after I clear the Ingore Blank, it
works well. But I also limit the order of delete, that means user has to
delete from A10 to a1 one by one in that order so I use formula like:
=if(a2<"", A1<"",A3=""),when a2 <"" means user input data, so check the
above cell a1 and only when a1<"" user can input, when a2="" mean user
delete data, and check below a3 and only when a3="" user can delete a2.
inserting works fine, but whne deleting even the formula is false, user can
still delete data? Could you help me fingure it out?

Clara
Thank you for your help