Allowing only 1 cell input in a cell range of 5

Giganews Newsgroups
Subject: Allowing only 1 cell input in a cell range of 5
Posted by:  anonymo…@discussions.microsoft.com
Date: Thu, 23 Oct 2003

>-----Original Message-----
>How do I set up 5 separate cells to only allow entry into
>1 of those cells?
>
>For example, in Column A, rows 1 -5, I want to be able to
>input an "X" into only one row, such as row 3. If I try
>to input into row 1, 2, 4, or 5, I want a message to pop-
>up saying that is not allowed.
>
>.
>Use your validation option under data.  It allows you to
restrict entry and leave a message for your user.

Replies

In response to

Allowing only 1 cell input in a cell range of 5 posted by AMM on Thu, 23 Oct 2003