I have a series of cells with drop down boxes, in a column (say column D), all drop down boxes in this column of cells having the same choices, and each drop down box having four choices for the user. These drop down boxes were created using Data Validation>List, etc. as usual. However I want any of these cells (say cell D4) to default to the first of the drop down choices automatically as soon as data is entered in a cell in the same row in a column next to the column of drop down boxes (say in cell B4).
For example, if the user enters a number, any number, in cell B4, I want cell D4 to show the text "Normal hours" (the first of the choices in the drop down list) without having to actually select from the list in the drop down choices of cell D4 (this being time-consuming as the normal option will be "Normal hours"). On the other hand, sometimes another choice from the drop down box will be required (say "Overtime" or "Holiday"), and that needs to be available to the user if he doesn't want the default option of "Normal hours".
How is this achieved?