This user's instinct is correct, even if their formula isn't. They want a conditional formatting rule that checks "Is today this specific date?" without forcing a helper cell into their spreadsheet. That is exactly the right approach. Helper cells are a crutch, not a feature. They clutter the sheet, shift the cognitive load onto the user, and make a simple visual alert feel like a workaround. The goal of any tool should be to let you express intent directly. This user is asking for that.
The problem is that Excel's conditional formatting dialog does not make this pattern obvious. The user tried `ISEQUAL(TODAY(), DATEVALUE(09/03/2026))`. That fails for two reasons. First, `ISEQUAL` is not a function in Excel. Second, `DATEVALUE` expects a text string in quotes, and the date format `09/03/2026` is ambiguous, Excel may read it as September 3 or March 9 depending on your locale. The correct formula is simple: select cell A1, open the conditional formatting rule, choose "Use a formula to determine which cells to format," and enter `=TODAY()=DATE(2026,3,9)`. That's it. No helper cells, no extra columns, no confusion. The rule fires only on that Monday.
What this user has stumbled into is a broader truth about modern spreadsheets. Legacy tools trained us to accept extra steps as normal. We add helper columns because we were told "that's how it's done." We tolerate cluttered sheets because we never saw a cleaner path. But a tool should bend toward the user's logic, not the other way around. The user's question, "I don't want to add the date somewhere else, I want to compare TODAY() with the date directly", is the right question. It is the question that pushes spreadsheet design forward. Every time a user refuses a workaround, they are asking for a tool that thinks the way they do.
The practical takeaway is this: next time you find yourself reaching for a helper cell to trigger a format change, pause. Ask if the date or value you are comparing can be written directly into the rule. Often it can. Conditional formatting formulas accept functions like `DATE`, `TODAY`, and `WEEKDAY` with no extra cells required. The rule lives entirely in the formatting dialog, invisible to the rest of the sheet, and your data stays clean. That is the outcome worth fighting for: a spreadsheet that does what you mean, without asking you to tidy up after it.