Google Sheet Formatting & Logic Upgrade
Budget: $10 – $30 CAD
I have an existing Google Sheet that is already populated with data but is starting to feel cluttered and a bit fragile. I need a tidy-up that does three things at once: sharpen the visual layout, tighten up the underlying logic, and make future analysis effortless.
Here’s what I’m after:
• Formatting & design
– Apply conditional formatting so key figures change colour automatically when they move above or below set thresholds.
– Standardise cell borders and shading so every section is clearly separated yet still easy on the eyes.
– Align text consistently and choose legible, professional fonts so nothing looks out of place.
• Formulas & functions
– Introduce or refine data-analysis functions that summarise trends at a glance (e.g., dynamic COUNTIF/QUERY combos, rolling averages).
– Build logical operations (IF, IFS, SWITCH, array formulas) that eliminate manual checks and reduce the chance of errors.
Acceptance criteria
1. All specified formatting rules trigger correctly when sample data is changed.
2. New or updated formulas return accurate results without breaking existing references.
3. The sheet remains share-friendly with protection rules only where truly necessary.
4. You provide a brief inline comment or note for every complex formula so future edits are straightforward.
Once you’re done, I’ll run a quick spot-check with fresh data to confirm everything behaves as expected, then we can wrap up.
Here’s what I’m after:
• Formatting & design
– Apply conditional formatting so key figures change colour automatically when they move above or below set thresholds.
– Standardise cell borders and shading so every section is clearly separated yet still easy on the eyes.
– Align text consistently and choose legible, professional fonts so nothing looks out of place.
• Formulas & functions
– Introduce or refine data-analysis functions that summarise trends at a glance (e.g., dynamic COUNTIF/QUERY combos, rolling averages).
– Build logical operations (IF, IFS, SWITCH, array formulas) that eliminate manual checks and reduce the chance of errors.
Acceptance criteria
1. All specified formatting rules trigger correctly when sample data is changed.
2. New or updated formulas return accurate results without breaking existing references.
3. The sheet remains share-friendly with protection rules only where truly necessary.
4. You provide a brief inline comment or note for every complex formula so future edits are straightforward.
Once you’re done, I’ll run a quick spot-check with fresh data to confirm everything behaves as expected, then we can wrap up.