|Subject:||Re: Allowing only 1 cell input in a cell range of 5|
|Posted by:||J.E. McGimpsey (jemcgimps…@mvps.org)|
|Date:||Thu, 23 Oct 2003|
Select A1:A5. Choose Data/Validation.
You can input your own message in the Error Alert tab of the
In article <024101c39996$79721690$a40128…@phx.gbl>,
"AMM" <anonymo…@discussions.microsoft.com> wrote:
> 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.
Allowing only 1 cell input in a cell range of 5 posted by AMM on Thu, 23 Oct 2003