Data Validation - Prevent delete

A

apache007

Hi guys,

I have user input on cell A1
and check cell on B1

After User enter his data on A1 and if the data is correct, manager fill
CELL B1 to confirm the entry.

After the manager fill CELL B1, we do not want any user to change A1, before
deleting B1 first.

What formula should I use in DATA VALIDATION to prevent deleting data on
Cell A1, when B1 is not empty?

Thanks in advance.
 
J

JLatham

Use 'Custom' and then use the formula
=B1=""
(you should be able to enter simply B1="" and Excel should insert the
leading = for you).
 
A

apache007

Jlatham,

Yes it works, when you try to enter new data.

However, if you press button "DELETE", it does not work.
It just delete right out.
Please help.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top