Users can enter in cells of column A, B and C but I have locked column D in which only I can enter data. After checking the data entered in column A, B and C, I will approve it by typing "OK" in column D.
After my approval, I want the data in column A, B and C to be locked.
For example,
Users enter data in A1, B1 and C1 and I approve it by typing "OK" in D1. After my approval, I want A1, B1 and C1 to get locked automatically, so that the users can no longer edit or delete the data in these cells.
After entering "OK" in D1, only A1, B1 and C1 should be locked, and the users should be allowed to enter in A2, B2 and C2... A3, B3 and C3 and so forth till "OK" is entered in D2 and D3 respectively, and so forth.
How can I apply this conditional locking in excel?