Conditional formatting should not require a PhD in spreadsheet logic. Yet here is a user, HardyMenace, asking a straightforward question: how to automatically color a cell when a report is 1-2 months, 3-5 months, or 6+ months past its due date. The fact that this simple need, track overdue reports with visual cues, stumps someone who clearly understands the basics tells you everything about the gap between what spreadsheets promise and what they deliver.
The problem is not HardyMenace. The problem is that traditional spreadsheets treat conditional formatting as a second-class feature, buried in menus and governed by arcane formula syntax that punishes anyone who hasn't memorized `DATEDIF` or nested `AND` statements. HardyMenace has the right instinct: they want a rule that says "if today minus due date falls in this range, paint the cell red." That is a natural, human way to think about deadlines. But the tool demands they translate that thought into a fragile combination of relative references, absolute cell locks, and date serial numbers. It is like asking someone to describe a color by giving its hexadecimal code instead of its name.
We think this is a clear sign that spreadsheet technology has not evolved to meet the way people actually work. Users should not have to "figure out" how to highlight overdue items. That is table-stakes functionality for any modern data tool, especially one that claims to handle time-sensitive reporting. The fact that a motivated user spends "for the life of me" trying to solve this indicates a systemic failure in user experience, not a knowledge gap. When the tool forces you to become a part-time programmer just to apply a traffic-light system to dates, the tool is the bottleneck.
The practical takeaway here is straightforward: if your workflow depends on tracking deadlines, and you find yourself wrestling with conditional formatting rules, you are not the problem. The tool is. An AI-native spreadsheet should let you describe the outcome in plain language, "highlight cells where the date is 1 to 2 months past due", and handle the logic automatically. That is not a futuristic wish; it is a baseline expectation for any system that claims to empower productivity. HardyMenace deserves a tool that treats their time as valuable, not a puzzle box.