I have a workbook with 4 adjacent colums. The user is to make an entry in ONLY one of these columns on each row. What I would like to happen is that if the user puts an entry in any of the 4 columns, the other three would be locked (or maybe even filled with a color) or otherwise unusable unless the entry in the other column was deleted. Any suggestions.
Bookmarks