Google Sheets Formula Creation

Google Sheets Expert Needed for Conditional Formatting & Formula Automation We are looking for a Google Sheets expert to help us build a few formulas and conditional formatting rules in an existing spreadsheet. Tasks include: - Creating conditional formatting rules that change cell colors based on dropdown status values. - Building date-based formulas that automatically highlight upcoming, overdue, and completed tasks. - Setting up formulas that trigger formatting based on dates and status changes. - Reviewing our spreadsheet and recommending simple improvements where appropriate. Requirements: - Strong experience with Google Sheets formulas and conditional formatting. - Familiarity with functions such as IF, AND, OR, TODAY, IFS, ARRAYFORMULA, INDEX/MATCH, VLOOKUP/XLOOKUP, and COUNTIF. - Ability to troubleshoot existing formulas and ensure everything works correctly. - Attention to detail and quick turnaround. This is a small project (approximately 1–2 hours) for someone experienced with Google Sheets. If it goes well, we may have additional spreadsheet automation work in the future. When you apply, please include a few examples of Google Sheets projects or automations you've built.