limit choice in cell to one of two values;

I have a cell where I want the user to ONLY to be able to
input the number "1" or "4".

Any help out there?

Check out Validation in XL Help.

In article <[email protected]>,
<[email protected]> wrote:

> I have a cell where I want the user to ONLY to be able to
> input the number "1" or "4".

Use Data Validation. Select List and type 1,4. HTH Otto
<[email protected]> wrote in message
news:[email protected]...
>I have a cell where I want the user to ONLY to be able to
> input the number "1" or "4".
>
> Any help out there?

Data, Validation, List

1,4

http://HelpExcel.com

"[email protected]" wrote:

> I have a cell where I want the user to ONLY to be able to
> input the number "1" or "4".
>
> Any help out there?
>