Conditionally protect cells

R

Rattlesnake

Hi,
I have an excel workbook that I share with another person in th
company.
The other person is responsible for entering data in some colums of
worksheet (say Column A,B,C,D) and I am responsible to enter data i
column's E,F,G,H.
The routine is that he enters the data in the Columns A,B,C,D and at
later time I update the Columns E,F,G,H.
Is there a way that I can lock the Column A,B,C,D if there is data i
the columns E,F,G,H.
i,e, once I update my columns , he SHOULD NOT be able to update hi
columns. They should be locked.

Thank
 
Top