I have a data validation list in cell E2. I want to prevent data entry in cell E3 if a selection has not been made in E2. Thus display an error message an lock E3
If a selection is made in E2 than I want to let a data value be entered in cell E3. Thus no message and unlock E3.
I need these actions to occur when focus is on cell E3.