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