Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking Cell through Validation
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking Cell through Validation
Select A2, then try this as the formula in DVAllowCustom:
=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" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking Cell through Validation
Thanks Max, for providing the clear solution for my query
Prem. "Max" wrote: Select A2, then try this as the formula in DVAllowCustom: =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" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking Cell through Validation
Welcome, Prem
-- Max Singapore http://savefile.com/projects/236895 Downloads:16,000 Files:354 Subscribers:53 xdemechanik --- "Premanand Sethuraman" wrote in message ... Thanks Max, for providing the clear solution for my query Prem. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking Data Validation Drop Down | Excel Discussion (Misc queries) | |||
Locking cell | Excel Discussion (Misc queries) | |||
Locking non-Validation cells in ranges | Excel Worksheet Functions | |||
locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
Locking a cell | Excel Worksheet Functions |