Data Validation List Questions

[DMS]

I have a few questions. (Note I cannot use Macros as a solution, I know that
would be easier but I can't)

1. Can you set a "default value" in a cell that is the first item in the
Validation List? This would mean that although the user can pick from the
list, The first item in the list automatically appears in the cell.

2. Can you replace the users selection with another from the list.
Think of this one like an OPtion Button. Lets say the user selects "X" in
the first cell. Later he selects "X" in the second cell. I need something
(Not a macro) that changes the First cells value from "X" to "".

Thanks in advance.

 

[Debra Dalgleish]

1) When you create the worksheet, you can enter default values in the
cells with data validation lists. Mark the cells (e.g. colour or
border), to indicate that users can change the data if required.

2) If cell A has a value selected from a data validation list, the only
way to change that entry, based on a selection in cell B, is by code.