Hi

Thanks for reverting...I am trying to creat a excel for my company where in
it will calculate the price of each product.

Now providing options to select from a drop down list containg various
values, like say if we select " special " from the drop down list then the
Cell H5 should be deactivated/lock & cell I10& J10 should get activated for
putting in the values for further calculations.once we select any other
option from the drop down list then cell I10& J10 should be deactivated &
Cell H5 should be activated for further claculations.

Please help me with the solution.

Regards
Ridhi

"Spiky" wrote:

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.