Apply Data Validation List only IF . . .
Just wondering if I could conditionally apply a DV drop down list to a cell
only if a referenced cell is equal to a certain value. I am using Excel 2003
and am looking for a NON macro solution.
-OR-
return the value of a cell (containing a DV drop down) to the first value of
the list (usually a blank) when the data in the named range changes and the
list is updated.
Again, not looking for a macro.
can either of these be done?
|