On Apr 21, 1:23 am, Ridhi wrote:
i WANTED TO LOCK & UNLOCK A CELL IN EXCEL DEPENDING UPON A VALUE THAT IS
RETURNED FRO A CELL, USING FORMULAS BUT CANNOT DO IT.PLEASE HELP

I don't think you can do this with formulas, you would need VBA. Maybe
if you describe what the worksheet is supposed to do, options could be
offered.

Data validation should be fairly useful as an alternative that doesn't
require locking the cell. It can prevent wrong answers entered by
direct typing, although not by copy/paste.