Lock a cell based on another cell's value

[clefrog]

[FONT=&quot]Hi[/FONT]
[FONT=&quot]I am trying to lock a cell (A1) based on the value of another cell (A2) (ie if the other cell's value is above 0) to prevent users from entering data in that cell in A1 if A2>0[/FONT]

How do I do this ?

Thanks for the help

 

[Yongle]

welcome to the forum


data validation in A1 with these settings

Allow:
Custom

with formula:
=A2<=0

 

[clefrog]

Thanks so much!