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