Order Sheet Update & Formatting

Замовник: AI | Опубліковано: 08.03.2026

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