Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello to you,
I have to create some validation in a particular worksheet: here comes the description of what I am looking for help on: The worksheet should allow the user to only enter data in only one of four possible cells, and in that particular cell, they can only be a score of a particular type, ie: 0, 0.5, 1, 1.5, 2, 2.5, 3, 3.5, 4. I am able to validate the cells to only input those scores mentioned (via list validation), but I have having trouble restricting usage to only one cell of the four. I really want to avoid using macros if possible, but if worse comes to worst, I am happy to take your advice on how to use them. Much obligued |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do i enter negative times in Excel & how can they be 'fiddled. | Excel Discussion (Misc queries) | |||
How do I format a cell in MS Excel to enable me to enter a mobile. | Excel Discussion (Misc queries) | |||
Office 97 to 2003: Excel: enter data w/fixed 2 decimal. 2000. be. | New Users to Excel | |||
Office 97 to 2003: Excel: enter data w/fixed 2 decimal. 2000. be. | New Users to Excel |