Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking Cell dependent on Another Cell Value
I've used Data Validation on cell B1 (allow=custom/formula =A10) for my application to allow entry on B1, however I also need to ensure the allowed data entry on B1 is a decimal value. Is there something I can add in the data validation to ensure a decimal value entry? Pls help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking Cell dependent on Another Cell Value
Hey, Ur Q is not proper, if u want only decimal validation u can select
Deceimal from Data Validation - Allow column. if you r looking something else, pls clear ur Q "el zorro" wrote: I've used Data Validation on cell B1 (allow=custom/formula =A10) for my application to allow entry on B1, however I also need to ensure the allowed data entry on B1 is a decimal value. Is there something I can add in the data validation to ensure a decimal value entry? Pls help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking Cell dependent on Another Cell Value
I'm not sure if I phrase my original question properly.
I have cell A1 and B1. B1 entry is dependent upon entry on A1. Data Validation is defined in B1. a) If A1 is populated with an entry of greater than 0 then I want B1 locked out (no entry is possible). b) However, if A1 is = or < 0 then I want B1 populated with a numeric entry in decimal value. I'm able to do a) based on my Data Validation entry below but not b). Is there something in the "Formula" that I can use to satisfy b) also? Thanks. "Muhammed Rafeek M" wrote: Hey, Ur Q is not proper, if u want only decimal validation u can select Deceimal from Data Validation - Allow column. if you r looking something else, pls clear ur Q "el zorro" wrote: I've used Data Validation on cell B1 (allow=custom/formula =A10) for my application to allow entry on B1, however I also need to ensure the allowed data entry on B1 is a decimal value. Is there something I can add in the data validation to ensure a decimal value entry? Pls help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking Cell dependent on Another Cell Value
Try this one in the "Formula":
=AND(A10,INT(B1)<B1) this will check A1 is 0 and B1 is entered decimal value. or =AND(A10,B10) this will check both cell is decimal value please do rate "el zorro" wrote: I'm not sure if I phrase my original question properly. I have cell A1 and B1. B1 entry is dependent upon entry on A1. Data Validation is defined in B1. a) If A1 is populated with an entry of greater than 0 then I want B1 locked out (no entry is possible). b) However, if A1 is = or < 0 then I want B1 populated with a numeric entry in decimal value. I'm able to do a) based on my Data Validation entry below but not b). Is there something in the "Formula" that I can use to satisfy b) also? Thanks. "Muhammed Rafeek M" wrote: Hey, Ur Q is not proper, if u want only decimal validation u can select Deceimal from Data Validation - Allow column. if you r looking something else, pls clear ur Q "el zorro" wrote: I've used Data Validation on cell B1 (allow=custom/formula =A10) for my application to allow entry on B1, however I also need to ensure the allowed data entry on B1 is a decimal value. Is there something I can add in the data validation to ensure a decimal value entry? Pls help. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking Cell dependent on Another Cell Value
Muhammed,
The formula works individually but not with the "AND". =A10 works ok by itself in the formula box =INT(B1)<B1 works ok by itself in the formula box =B10 works ok by itself in the formula box But they don't work when combined using the "AND" function. Am I doing something wrong? Thanks for you patience. "Muhammed Rafeek M" wrote: Try this one in the "Formula": =AND(A10,INT(B1)<B1) this will check A1 is 0 and B1 is entered decimal value. or =AND(A10,B10) this will check both cell is decimal value please do rate "el zorro" wrote: I'm not sure if I phrase my original question properly. I have cell A1 and B1. B1 entry is dependent upon entry on A1. Data Validation is defined in B1. a) If A1 is populated with an entry of greater than 0 then I want B1 locked out (no entry is possible). b) However, if A1 is = or < 0 then I want B1 populated with a numeric entry in decimal value. I'm able to do a) based on my Data Validation entry below but not b). Is there something in the "Formula" that I can use to satisfy b) also? Thanks. "Muhammed Rafeek M" wrote: Hey, Ur Q is not proper, if u want only decimal validation u can select Deceimal from Data Validation - Allow column. if you r looking something else, pls clear ur Q "el zorro" wrote: I've used Data Validation on cell B1 (allow=custom/formula =A10) for my application to allow entry on B1, however I also need to ensure the allowed data entry on B1 is a decimal value. Is there something I can add in the data validation to ensure a decimal value entry? Pls help. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking Cell dependent on Another Cell Value
Its working for me, u just copy
=AND(A10,INT(B1)<B1) and paste to "Confitional formatting formula area "el zorro" wrote: Muhammed, The formula works individually but not with the "AND". =A10 works ok by itself in the formula box =INT(B1)<B1 works ok by itself in the formula box =B10 works ok by itself in the formula box But they don't work when combined using the "AND" function. Am I doing something wrong? Thanks for you patience. "Muhammed Rafeek M" wrote: Try this one in the "Formula": =AND(A10,INT(B1)<B1) this will check A1 is 0 and B1 is entered decimal value. or =AND(A10,B10) this will check both cell is decimal value please do rate "el zorro" wrote: I'm not sure if I phrase my original question properly. I have cell A1 and B1. B1 entry is dependent upon entry on A1. Data Validation is defined in B1. a) If A1 is populated with an entry of greater than 0 then I want B1 locked out (no entry is possible). b) However, if A1 is = or < 0 then I want B1 populated with a numeric entry in decimal value. I'm able to do a) based on my Data Validation entry below but not b). Is there something in the "Formula" that I can use to satisfy b) also? Thanks. "Muhammed Rafeek M" wrote: Hey, Ur Q is not proper, if u want only decimal validation u can select Deceimal from Data Validation - Allow column. if you r looking something else, pls clear ur Q "el zorro" wrote: I've used Data Validation on cell B1 (allow=custom/formula =A10) for my application to allow entry on B1, however I also need to ensure the allowed data entry on B1 is a decimal value. Is there something I can add in the data validation to ensure a decimal value entry? Pls help. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking Cell dependent on Another Cell Value
In your second message you said B1 should be locked if A10. If that's
what you want, then this data validation should work in cell B1: =AND(A1<=0,INT(B1)<B1) You may also want to remove the check mark for Ignore Blank, or you'll be able to enter anything in cell B1 if A1 is blank. el zorro wrote: Muhammed, The formula works individually but not with the "AND". =A10 works ok by itself in the formula box =INT(B1)<B1 works ok by itself in the formula box =B10 works ok by itself in the formula box But they don't work when combined using the "AND" function. Am I doing something wrong? Thanks for you patience. "Muhammed Rafeek M" wrote: Try this one in the "Formula": =AND(A10,INT(B1)<B1) this will check A1 is 0 and B1 is entered decimal value. or =AND(A10,B10) this will check both cell is decimal value please do rate "el zorro" wrote: I'm not sure if I phrase my original question properly. I have cell A1 and B1. B1 entry is dependent upon entry on A1. Data Validation is defined in B1. a) If A1 is populated with an entry of greater than 0 then I want B1 locked out (no entry is possible). b) However, if A1 is = or < 0 then I want B1 populated with a numeric entry in decimal value. I'm able to do a) based on my Data Validation entry below but not b). Is there something in the "Formula" that I can use to satisfy b) also? Thanks. "Muhammed Rafeek M" wrote: Hey, Ur Q is not proper, if u want only decimal validation u can select Deceimal from Data Validation - Allow column. if you r looking something else, pls clear ur Q "el zorro" wrote: I've used Data Validation on cell B1 (allow=custom/formula =A10) for my application to allow entry on B1, however I also need to ensure the allowed data entry on B1 is a decimal value. Is there something I can add in the data validation to ensure a decimal value entry? Pls help. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking Cell dependent on Another Cell Value
Debra and Muhammed,
Yes they worked, it was an operator error on my side. Thanks much. "el zorro" wrote: I've used Data Validation on cell B1 (allow=custom/formula =A10) for my application to allow entry on B1, however I also need to ensure the allowed data entry on B1 is a decimal value. Is there something I can add in the data validation to ensure a decimal value entry? Pls help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to lookup value in cell, dependent on value in another cell | Excel Worksheet Functions | |||
Cell locking dependent on Cell value | Excel Discussion (Misc queries) | |||
Dynamically locking a cell depending upon value of another cell. | Excel Discussion (Misc queries) | |||
Cell dependent on another | Excel Discussion (Misc queries) | |||
Cell value dependent on another cell entry | Excel Discussion (Misc queries) |