Automated Service Member Tracking Spreadsheet

Service Member Excel Tracker.
I need an Excel spreadsheet with automated formatting and drop-down lists.

Conditional Formatting – The "Action" cell will turn red if more than 3 days have passed since the date was entered.

Drop-Down Menus –
"Types of Service" in Column B
"Reason(s) for Visit" in Column I with all the requested options below:

• Army Credentialing Assistance
• ArmyUniversity BNCEDP
• ArmyIgnitED Enrollment
• ArmyIgnitED Problems
• ArmyIgnitED Information
• ArmyU Credentialing
• BSEP Counseling
• Chapter Counseling
• College Information
• Commissioning Assistance
• Dashboard
• Exception to Policy Counseling
• Financial Aid Information
• HE Track Counseling
• High School Completion
• In-Processing
• Memo for Soldier
• Military Spouse Career Advancement Accounts (CAA)
• Org Box
• Out-Processing
• Out-Processing (PCS) Request
• Quality Trigger
• Tuition Assistance
• Talk with an On-Post School Representative
• Test Information
• Transcript Request
• VA Education Benefits (MGIB, VEAP, Top-Up)
• Withdraw from a Class
• Other

• Column B: Last Name
• Column C: First Name
• Column D: DODID ID
• Column E: Date
• Column F: Phone Number
• Column G: Email
• Column H: Notes (Wrap Text)