Clean & Format Complex Spreadsheet
Budget: ₹12,500 – ₹37,500 INR
I have a single spreadsheet—originally supplied by a client—filled with mixed text and numerical data that is currently bulky and hard to read. I need it turned into a polished, presentation-ready workbook.
Specifically, every range must be organized into clear tables with consistent borders and subtle shading so different sections stand out at a glance. I also need practical conditional-formatting rules applied (for example, automatic colour coding of key thresholds, duplicates, or blanks) so the most important figures pop without manual scanning.
The file is in Excel right now, though I may also open it in Google Sheets, so whatever you build should work seamlessly in either environment. No database work or scripting is required—just thorough, thoughtful spreadsheet design.
Deliverables
• The fully formatted spreadsheet returned in .xlsx (and optionally shared in Google Sheets).
• A short note that lists the conditional-formatting rules you created so I can adjust them later if needed.
I will consider this complete when the sheet looks clean, is easy to navigate, and all conditional formats behave exactly as described.
Specifically, every range must be organized into clear tables with consistent borders and subtle shading so different sections stand out at a glance. I also need practical conditional-formatting rules applied (for example, automatic colour coding of key thresholds, duplicates, or blanks) so the most important figures pop without manual scanning.
The file is in Excel right now, though I may also open it in Google Sheets, so whatever you build should work seamlessly in either environment. No database work or scripting is required—just thorough, thoughtful spreadsheet design.
Deliverables
• The fully formatted spreadsheet returned in .xlsx (and optionally shared in Google Sheets).
• A short note that lists the conditional-formatting rules you created so I can adjust them later if needed.
I will consider this complete when the sheet looks clean, is easy to navigate, and all conditional formats behave exactly as described.