Users, we are a frustrating lot, eh?! <g I'm having to deal with
useres myself after being called back to a great place to work that
I'd left after that first contract's end last summer. The Excel file
I'd created then for my own use and that of my supervisor only is now
shared with an additional 6 people! Boy, the trouble they get into!
<g

They're messing up one of my reports because the cell that should only
be blank or have an "X" in it for completed, as per the pulldown
boxes!, has comments in it that should go in an adjacent cell. Since
we now have several hundred entries hadn't noticed this till now.

Is there a way to restrict input to either a blank cell or the "X"?
It would be too limiting to not have the blank cell in the value list
for the data validation field because once you've selected that "X",
watch out, you can't then take the X off to change the state to still
pending. That's the only way I know to restrict the data and it's too
much restriction.

Is there a way to do this? Tx.