comparing cell values to wildcards in a string?

[robfritts]

I'm looking for a VBA argument to help me define criteria. I tried the conditional formatting, but I can't figure out how to type this formula. I want to ClearContents or DeleteRow for any cell value that is not in for format ##XXXXXX, where # is any numeric and X is any alpha character. I also want to do conditional formatting and highlight a cell if the criteria is "xxxxxxCEx3T" where
x is any alpha character. Am I just not finding the right wildcards to do this or using the wrong format/argument?

In case you couldn't tell, I'm new.

 

[Legacy 98055]

Use the Like Operator
<pre>

MatchPattern = YourValue Like "##??????"
'if MatchPatter = False then delete your row
MatchPattern = YourValue Like "??????CE?3T"
'if MatchPatter = True then do your formatting

</pre>
Tom