Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
I have created a list in column E which contains 3 values. If the use selects a value from this list, but the cell on column C is blank (also a list), I want to issue a warning to the user to tell them to put a value column C (which is also a list) before they can pick from the list in column E. I presume I must use data validation for this, and have been experimenting, but I'm not sure how to combine the original list and an 'if' formula within the same rule Would appreciate any help Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Validation Excel 2003 | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Tricky problem in Data validation - Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 - Data Validation | Excel Discussion (Misc queries) | |||
Conditional Data Validation possible in Excel 2003? | Excel Discussion (Misc queries) |