I've got an Excel worksheet set up where there are two columns for each day
of the month. There are ten rows. A user should put an X (I'm using a
colored-fill) in just ONE box in each column every day. The user should be
able to change where to put the X, but shouldn't be able to enter more than
one single sole solitary X in each column.

I have no idea how to go about this.

Right now, the sheet allows the user to enter anything they want in all ten
columns.

I also want to limit what the user can enter into the box they choose -- I'd
prefer for them to choose a box and have it color-filled with black or dark
blue, whatever; and for all the rest of the boxes/rows in that particular
column to then prohibit entry.

Am I making sense? Am I on the right group?


--
Lady Dungeness
Crabby, but Great Legs!