I would like to implement a strategy to highlight a particular field on an Excel form so that people will fill it in every time.
At the moment, this field contains a drop-down list which defaults as empty when the Excel file is opened. Selecting an item from the drop-down populates the field.
I would like to do something along these lines (not necessarily all of them, it depends on how difficult they are to implement):
1. Have the first item in the list say something like "Select Item" and have it flash on and off until the item is chosen.
2. Have some text sitting next to the drop-down which flashes on and off saying to "Select Item" until an item is chosen (and then the text goes blank).
3. Force this particular drop-down to be selected before any other field on the Excel form and be edited / updated, kind of like selecting the field unlocks the spreadsheet.