Validation Settings

We created a spreadsheet that adds up the hours for each Account for any day of the week. The drop down list was created with Data Validation and used a small list of names on the Accounts worksheet. You named that list of names "clients" to make it easy to reference. Finally, you added Conditional Formatting to make an interactive form that is user friendly.