Locking Cell through Validation

[Premanand Sethuraman]

Dear All,
I am working in a program in which I want to lock a Cell in such a way like
if A1 = "Boiler" , then Cell A2 should not allow the user to enter the
number more than 28,800. If A1 = Any text other than boiler then Cell A2 can
alow the user to enter the number more than 28,800 but should not be more
than 68,000.
Please guide me how I can I do this with Data Validation. I tried with Data
Validation---> Allow---> Custom, but in vain.

Thanks and Regards,
Premanand.S

 

[Max]

Select A2, then try this as the formula in DV>Allow>Custom:
=OR(AND(A1="Boiler",A2<=28800,ISNUMBER(A2)),AND(A1<>"Boiler",A2<=68800,ISNUMBER(A2)))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:15,900 Files:354 Subscribers:53
xdemechanik

 

[Premanand Sethuraman]

Thanks Max, for providing the clear solution for my query
Prem.

 

[Max]

Welcome, Prem
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,000 Files:354 Subscribers:53
xdemechanik