This user's question is a perfect example of something we see all the time: a simple, practical need that legacy tools make unnecessarily hard. They want to highlight cells when the first five characters in one column match the first five in another, with the records out of order and no helper column. That should be straightforward. In most traditional spreadsheets, it is not.
The core issue here is that conditional formatting formulas in tools like Excel or Google Sheets often require a helper column to perform a partial-text match across two unordered lists. You end up writing a formula that works, but it relies on an extra hidden column that clutters your file and feels like a workaround, not a solution. For the user, the frustration is real: they know what they want to see (matching rows highlighted instantly), and they know the logic is simple, yet the software forces them to bend their workflow around its limitations.
We believe that a modern spreadsheet should handle this in one step. The ideal solution is a conditional formatting rule that uses a formula like `=SUMPRODUCT(--(LEFT($A1,5)=LEFT($B$1:$B$100,5)))>0` or, in newer tools, a built-in function that directly compares partial strings across ranges. But the fact that this user has to ask, that they are searching for a "simple solution," tells you the gap between what people need and what traditional tools deliver. It is not about the user lacking skill, it is about the tool lacking foresight.
What this means in practical terms is that you should not accept the inefficiency. If you find yourself regularly needing to add helper columns for basic pattern matching, that is a sign your spreadsheet is not designed for the way you actually work. The next generation of data tools, especially those with AI-native capabilities, can understand intent like "highlight matches of the first five characters" without requiring you to construct a workaround. The question is not whether you can do it without a helper column. The question is why you should have to.