This is a smart, practical question, and it reveals something most spreadsheet users learn the hard way: the tools they rely on every day make simple tasks harder than they need to be.
The user wants a clear rule: if column B has data and column C is blank, highlight that blank cell yellow. In a traditional spreadsheet, the answer involves a conditional formatting formula like `=AND($B1<>"", $C1="")`, applied to the entire column C range. It works. It is also, frankly, a workaround for a missing native feature. The user is not asking for anything exotic. They are asking for a basic data-quality check: flag incomplete rows so they can fix them. That should be a one-click toggle, not a formula hunt.
What this tells us is that legacy spreadsheets still treat conditional logic as an advanced skill. The user has to know the syntax, the cell referencing rules, and the difference between absolute and relative references just to highlight a blank cell. That is not empowering. It is a barrier. The real insight here is that the user's goal is not "write a formula." The goal is "see which rows need my attention." The formula is just the current cost of entry.
We believe the future of spreadsheets should eliminate that cost. Instead of asking users to translate a plain-English intent into a formula, the tool should understand the intent directly. Tell the system: "Highlight column C yellow when B is filled and C is empty." That is a clear, human statement. An AI-native spreadsheet would parse that, apply the rule across all rows, and let the user move on to the actual work, fixing the missing data. The user in this post has already done the hard part: they know exactly what they want to see. The software should meet them there, not demand a detour through documentation.
So, our take is straightforward: this question should not need to be asked. The user's workflow is correct, their logic is sound, and their request is reasonable. The fact that they had to post it as a question is not a reflection on them. It is a reflection on the tools we have settled for. The next generation of spreadsheets will treat "highlight blanks" as a built-in behavior, not a formula challenge. Until then, the formula above works. But do not mistake a working solution for a good one.