Forum Discussion
How to conditionally format a cell that has two numbers instead of one?
npshibzk Just re=reading what you wrote:
I highlighted every cell that contains "METER" or "MTR" thus far to help narrow it perhaps.
Did you do that highlighting using conditional formatting? Or was that a manual thing just for this posting? If you did it yourself using conditional formatting, maybe that's your quick and dirty solution.
But still would require a lot of work. It is a mess!
Yep. But a series of manual fixes, accelerated by just searching for METER, MTR, or even #.... and you could do that using a "helper column" next to the "Remarks" column.
In fact, after writing that, I went and wrote the formula for you. Here it is. I added multiple helper columns, with a "search term" at the top.... you could extend this. As you see, it will pick up and highlight the row that contains METER, meter, MTR, mtr, #. and any combination of those..... So all you need to do is put some temporary helper columns next to your "Remarks" and copy these formulas down all 11,000 rows. It'll still be work, but that should accelerate it.
Is there some particular reason why you use Excel for this business purpose in the first place? Does the worksheet also track hours or expenses associated with a call, for example? Assuming that is the case, it makes even more sense that the Meter Number be its own cell/column.
If you want further assistance or suggestions, might I ask that you upload a sample or two of the way it looks now, i.e., a representative spreadsheet with some filled in as you want, and one or two that are not.