So the 4 cells in a row (B5:E5) that I have each contain a different value. I want the user to only be able to choose one of the 4 cells - that is, if any of the 4 cells are filled in, I would like the other 3 to default to N/A (or somehow not be allowed to be chosen). Can someone provide me with the formula for this? Also, Can you tell me if there is a way that once a cell is checked the others gray out?
Example of Question: Rate your Service Poor Fair Good Excellent
X
Bookmarks