| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation - lists if certain column is certain value
Hi,
I've got a simple register/task allocation spreadsheet and I want Data Validation on the "task" cell to operate in the following manner: If "present" cell is "NO" then only allow certain values (Sick, AWOL, etc) If "present" cell is "YES" then allow any value Any ideas? I've played around with custom functions to try and achieve this without any luck :-( George |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation lists help? | Excel Worksheet Functions | |||
| Data validation and lists | Excel Programming | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
| Data Validation (2 lists) | Excel Discussion (Misc queries) | |||
| data validation lists | Excel Discussion (Misc queries) | |||
Threaded Mode
