If the data in Column B is strictly for *display only* (no calculation
needed), then you might try this:

Say you're looking to configure B1 to B25,

Select the range B1:B25, then:
<Data <Validation <Settings tab,
Under Allow, click on "List",
Under Source, enter:
High,Mod
Then <OK

While the range is *still* selected, click,
<Format <Conditional Formatting
Change "Cell Value Is",
To "Formula Is",
And enter this in the box to the right:

=A1<3

Then click on "Format", and the "Font" tab,
Expand the Color box, and choose the White,
Then <OK <OK.

This should give you the restricted display you're looking for.

Don't forget though, the data choices *will* exist in Column B, but will not
be visible, meaning that you *cannot* reference Column B in any formulas.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

Restrict entry to 2 options,

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