Excel Automation and Highlighting
Budget: $30 – $250 USD
I need an Excel 365 expert to automate highlighting and formula copying in my spreadsheet.
Requirements:
- Printing: Ensure the sheet fits nicely for printing, whether it has 1 row or 40 rows.
- Autocopy Formula: Automatically copy formulas to newly added rows without converting the sheet into a table.
- Conditional Highlighting:
- Compare paired cells in columns I & J, L & M, and O & P.
- Highlight the cell pair with the lowest value in yellow (Color 65535).
- If two pairs have the lowest value, highlight both in red.
- Highlight both cells in each pair together.
- Exclude cells with text, blanks, or black fill.
- Highlighting must update automatically when values change.
- Ctrl+Z functionality should remain intact.
Ideal Skills and Experience:
- Advanced Excel 365 proficiency
- Experience with conditional formatting and automation
- Ability to create user-friendly solutions without disrupting existing functionalities
Requirements:
- Printing: Ensure the sheet fits nicely for printing, whether it has 1 row or 40 rows.
- Autocopy Formula: Automatically copy formulas to newly added rows without converting the sheet into a table.
- Conditional Highlighting:
- Compare paired cells in columns I & J, L & M, and O & P.
- Highlight the cell pair with the lowest value in yellow (Color 65535).
- If two pairs have the lowest value, highlight both in red.
- Highlight both cells in each pair together.
- Exclude cells with text, blanks, or black fill.
- Highlighting must update automatically when values change.
- Ctrl+Z functionality should remain intact.
Ideal Skills and Experience:
- Advanced Excel 365 proficiency
- Experience with conditional formatting and automation
- Ability to create user-friendly solutions without disrupting existing functionalities