Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
latest entry | Excel Worksheet Functions | |||
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) | |||
double-clicking a list entry | Excel Discussion (Misc queries) | |||
Move the last entry in a column to a different cell, when the loc. | Excel Worksheet Functions |