|Subject:||Allowing only 1 cell input in a cell range of 5|
|Posted by:||AMM (anonymo…@discussions.microsoft.com)|
|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.