|Subject:||Allowing only 1 cell input in a cell range of 5|
|Date:||Thu, 23 Oct 2003|
>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.
Allowing only 1 cell input in a cell range of 5 posted by AMM on Thu, 23 Oct 2003