| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Force entry to one of three cells
I have a sheet where users enter a value of an invoice in one of three
columns. These are Pounds sterling, US dollar and Euro. The invoice will only ever be in one of the three currencies. Can I flag a warning if values appear in more than one of the three cells on each row? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| limit text entry in a range of cells | Excel Discussion (Misc queries) | |||
| Is there away to have specific cells unlock based on the entry of information in another? | New Users to Excel | |||
| data entry from two cells across worksheets | Excel Discussion (Misc queries) | |||
| How to you count cells that contain any entry? | Excel Discussion (Misc queries) | |||
| Selected cells grow and data entry impossible EXT is dissabled | Excel Discussion (Misc queries) | |||
Threaded Mode
