| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Check 3 cells, only one of the cells my be filled
I have 3 cells called "overtime" Traveltime"and "Servicetime"
Those cells are in a single row. I am looking for a way so that only ONE of those cells are allowed to be filled with the letter "J". So only one cell i allowed. When already a cell is filled, the a message must be poped up like "already one value entered, only one value is allowed". I hope somebody can help me out here!! thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average only if all cells filled | Excel Discussion (Misc queries) | |||
| Average only if ALL cells filled. | Excel Worksheet Functions | |||
| Filled cells dont appear as filled | Excel Discussion (Misc queries) | |||
| Percentage of filled cells | Excel Worksheet Functions | |||
Threaded Mode
