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...

CodePudding user response：

Use this as the rule:

=ISNUMBER(SEARCH("????-???",$A1))

And apply it to the columns desired: