Inventory Excel Formatting & Accuracy
Budget: ₹750 – ₹1,250 INR
My inventory spreadsheet tracks every SKU, batch number, quantity on-hand, and expiry date for several warehouses. I need the file cleaned and checked line-by-line so every figure is 100 % accurate—no typos, no misplaced decimals, no missing rows.
Once the data is verified, set up clear, self-updating colour-coding that flags expiry status at a glance. I’d like an intuitive scheme (for example: red for expired, amber for items expiring within 30 days, green for everything else), applied through conditional-formatting rules so the colours update automatically whenever dates change.
Deliverables
• A single, fully validated Excel workbook with all original columns intact
• Conditional-formatting rules implementing the expiry-based colour system
• A brief note (one sheet or inline comments) explaining the rules you built so I can tweak thresholds later if needed
Everything has to remain fast and readable on any recent version of Excel; no external add-ins. If you can turn this around quickly while keeping absolute accuracy, let’s get started.
Once the data is verified, set up clear, self-updating colour-coding that flags expiry status at a glance. I’d like an intuitive scheme (for example: red for expired, amber for items expiring within 30 days, green for everything else), applied through conditional-formatting rules so the colours update automatically whenever dates change.
Deliverables
• A single, fully validated Excel workbook with all original columns intact
• Conditional-formatting rules implementing the expiry-based colour system
• A brief note (one sheet or inline comments) explaining the rules you built so I can tweak thresholds later if needed
Everything has to remain fast and readable on any recent version of Excel; no external add-ins. If you can turn this around quickly while keeping absolute accuracy, let’s get started.