Order Sheet Update & Formatting
Budget: ₹220 – ₹380 INR
I need my existing Google Sheet brought fully up-to-date with the latest order details. Please add every new record into the main “Orders” tab so it functions as a clear table with rows and columns, not as separate sheets or split sections.
While you are entering the data, give the sheet a quick visual overhaul:
• keep the header row bold and wrap a simple grid border around the whole table
• set up colour-coding so each row changes automatically according to the order’s current status
• add conditional-formatting rules that highlight specific values I’ll identify (e.g. “Overdue”, “Refunded”).
The formatting must remain dynamic, applying itself to any future rows I append. Work directly in Google Sheets and note any formulas or rules you create so I can tweak them later.
Deliverables
– All provided order details accurately inserted in the “Orders” tab
– Bold headers with borders in place
– Row colour-coding by status functioning correctly
– Conditional-formatting rules triggering as specified
– Short note or comment explaining the rules applied
While you are entering the data, give the sheet a quick visual overhaul:
• keep the header row bold and wrap a simple grid border around the whole table
• set up colour-coding so each row changes automatically according to the order’s current status
• add conditional-formatting rules that highlight specific values I’ll identify (e.g. “Overdue”, “Refunded”).
The formatting must remain dynamic, applying itself to any future rows I append. Work directly in Google Sheets and note any formulas or rules you create so I can tweak them later.
Deliverables
– All provided order details accurately inserted in the “Orders” tab
– Bold headers with borders in place
– Row colour-coding by status functioning correctly
– Conditional-formatting rules triggering as specified
– Short note or comment explaining the rules applied