cond format

J

jon

Hi Everyone.
Is there any way to have a column conditionally formatted
so they can only enter in one of five answers "yes, no,
maybe, definately, and never"?

I've tried in lots of places but can't find anything.

TIA
 
E

ElsiePOA

I think you should be looking at Data Validate rather than Conditiona
Formatting. The purpose Conditional Formating is to vary the cell'
format based on conditions you establish while Data Validate allows yo
to specify what cell contents are allowed
 
B

Biff

Hi Jon!

What you want is data validation. Here are a couple of
ways to do that.

Select the range of cells in question.
Goto Data>Validation
In the Allow dropdown, select Custom.
In the Formula box you have a couple of options. Enter one
of these formulas:
1. enter this formula: =(OR
(A1="YES",A1="NO",A1="MAYBE",A1="DEFINITELY",A1="NEVER") I
used col A in this example.
2. Or, in an out of the way area of the sheet list the
entries that you will accept. Say that list is in the
range K2:K6. Enter this shorter formula: =OR(A1=K$2:K$6)
Or you could even give the range K2:K6 a name and use that
name in the formula: =OR(A1=RANGE). You can select to use
the optional input/error messages if you like.

Biff
 
J

jon

Thanks Biff, Exactly What I needed.

jon
-----Original Message-----
Hi Jon!

What you want is data validation. Here are a couple of
ways to do that.

Select the range of cells in question.
Goto Data>Validation
In the Allow dropdown, select Custom.
In the Formula box you have a couple of options. Enter one
of these formulas:
1. enter this formula: =(OR
(A1="YES",A1="NO",A1="MAYBE",A1="DEFINITELY",A1="NEVER") I
used col A in this example.
2. Or, in an out of the way area of the sheet list the
entries that you will accept. Say that list is in the
range K2:K6. Enter this shorter formula: =OR(A1=K$2:K$6)
Or you could even give the range K2:K6 a name and use that
name in the formula: =OR(A1=RANGE). You can select to use
the optional input/error messages if you like.

Biff
.
Click to expand...
 
Top