Google Sheets Dropdown Formula

I'm looking for an expert in Google Sheets to create a dropdown formula that dynamically updates and applies conditional formatting.

Requirements:
- Implement in Google Sheets
- Dropdown options will contain text
- Functions must include dynamic updating and conditional formatting

Ideal Skills and Experience:
- Proficient in Google Sheets
- Experience with dropdown menus, dynamic functions, and conditional formatting
- Attention to detail and problem-solving skills