Okay so I’ve spent some time digging through stack overflow other various websites, I’m not even sure this is possible but here’s the example.
I have an excel sheet with quite a bit of information, in column A there are various types of information however I specifically only want the cells that have #####-###.
The issue is that the other users will sometimes replace the last 3 digits with question marks and similarly, when adding the dash it doesn’t treat it as a number it’s considered general format…
Like I said I maybe have the number 60613-555, then right below it part numbers/names etc, so I only want that cell with the project number to have the top line border…
>Solution :
Use this as the rule:
=ISNUMBER(SEARCH("????-???",$A1))
And apply it to the columns desired:
