Conditional formatting with formulas and Wildcards- Microsoft Excel

In this video, I demonstrate an example of Conditional formatting using a formula and wildcards.

Workbook can be found here:

[fityfofilms]

Exactly what I was looking for. Thanks!

[nonoobott]

Very neat solution. I'd have done it differently though. Here are two ways still using Conditional Formatting with a Formula:

#1
=ISERROR(SEARCH("A??T", $A2))

#2
=NOT(AND(LEFT($A2, 1)="A", LEN($A2)=4, RIGHT($A2, 1)="T"))

These should work too