This user is doing everything right conceptually, and everything wrong mechanically. The logic is sound, check if column J equals "1A" and column I equals "HM," then paint the cell yellow. That's exactly how conditional formatting should work. But the formula isn't firing, and the frustration is real. The problem isn't the idea. It's the tools.
Traditional spreadsheets treat conditional formatting as an afterthought. You write a formula, apply it to a range, and hope the engine interprets your intent correctly. Too often, it doesn't. The formula syntax is brittle, the scope is confusing, and there's no feedback loop telling you why the cell stayed white. The user here is stuck in that gap between what should happen and what the software actually does. That gap is where productivity goes to die.
What this user needs is a system that understands combinations natively. When your data has product types and attributes that cross-reference in dozens of ways, you shouldn't have to hand-code each conditional rule. You should be able to say: "For every row where product equals 1A and attribute equals HM, make the cell blue." And the tool should just do it. No wrestling with absolute references. No guessing whether the formula applies to the active cell or the entire range. No silent failures.
This is exactly the kind of task that an AI-native spreadsheet handles differently. Instead of forcing you to translate your logic into a formula language that predates the web, it lets you describe the rule in plain terms. The system interprets the combination, applies the formatting, and shows you what changed. If something doesn't work, it tells you why. The friction disappears.
We're not saying traditional spreadsheets are useless. They've served millions of users for decades. But when a simple task like coloring a cell based on two conditions becomes a troubleshooting exercise, it's time to ask whether the tool is working for you or against you. The user's goal is straightforward. The solution should be too.