Here's what I want to do I have(for simplicity)rows 1-5
and col. A-E. For input reasons in A1-5 the value is
either 1 or its empty AND if a 1 is entered in one cell
then entered in another it removes it from the prior.

Basically within the range blank or 1 and in one cell

How do I go about this?