ExcelBanter - 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!!!