Pattern matching against Excel worksheet data

I have an excel worksheet with multiple columns of data of which I am trying to find any strings with within the rows that is matches the pattern with format XnnnnnnnX; where X is any alphabet[A-Z] and n is a number [0-9]. Alphabets are non-case sensitive. There are exactly 7 numbers [n] in this pattern. Example: S1234567J or T1231112J Upon finding the pattern, I will need to highlight it or colorise it.

Is there any way to achieve this in excel without using regex?

Thanks in advance!