A
apache007
Sorry for reposting this, but still got no solution for this.
Help please ??
============================
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
==============================
============
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
Help please ??
============================
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
==============================
JLatham said:Use 'Custom' and then use the formula
=B1=""
(you should be able to enter simply B1="" and Excel should insert the
leading = for you).
============
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