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:  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.

Replies