| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Do not allow an entry in a cell if another cell has an entry.
I have a spreadsheet that users fill in for an audit. They need to enter an x
in one or four rating columns. I can limit the value entered and force an x through validaion with no problem. What I need to do is to allow an x in only one column. There are four rating columns B, C, D and E. If they put an x in column B, then I do not want them to be able to put an x in columns C, D or E. Likewise, if they put an x in column C, then B, D and E must be blank. How do I allow only one column to have an entry? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Control Data Entry - push entry to next cell | Excel Discussion (Misc queries) | |||
| restricting entry into a cell based on entry to a previous cell | New Users to Excel | |||
| Creating a separate cell entry for every individual line in a cell | Excel Discussion (Misc queries) | |||
| Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
| enter a time into a cell, have the cell show two times the entry | Excel Worksheet Functions | |||
Threaded Mode
