If you cannot open an Excel file and see Excel cannot open the file because the file format or extension is not valid error, see this post.

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.