| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Restricting entry in B1 on the basis of entry in A1
"Biff" wrote in message news:... Hi! Select the range of cells you want to validate. Goto DataValidation Allow: Custom Formula: =AND(ISNUMBER(A1),A12,OR(B1="High",B1="Mod")) Uncheck: Ignore blank OK Biff "Stilla" wrote in message ... Is there a way, using formulas, or validation settings to restrict entry in one cell based on what is entered in other cells? Example. If values in Col A are less than 3, I would like the user NOT to be able to enter ANYTHING IN col B. IF values in Col A are 3 or more however, I would like the user to have a choice of two other ratings...say High, Moderate. so that final data could look something like this: A B 4 High 1 BLANK (this cell would be restricted) 5 Mod 2 BLANK (this cell would be restricted) 3 High 4 Mod 5 Mod THank You!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Restricting entry in B1 on the basis of entry in A1 | Excel Worksheet Functions | |||
| latest entry | Excel Worksheet Functions | |||
| data entry form Excel | Excel Discussion (Misc queries) | |||
| How do you create a selection box for data entry within excel | Excel Discussion (Misc queries) | |||
| limit text entry in a range of cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
