Conditional Formatting with Wildcard

[zacgc5]

Hello,

I need to conditional format a set of cells if the data starts with an A and ends with a 2. I have cells with A02, A12, A22 and so on, and would like these all to get colored.

Any help is appreciated!

Thanks!

 

[etaf]

Book2
	A	B	C
1	a12342		1
2	b123452		0
3	1234		0
4	2		0
5	a2		1
6	a123432		1
Sheet1

Cell Formulas
Range	Formula
C1:C6	C1	=COUNTIF(A1,"A*2")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A:A	Expression	=COUNTIF(A1,"A*2")>0	text	NO

 

[6StringJazzer]

Select all the cells to format then create a rule using a formula:

=ISNUMBER(SEARCH("A*2",A2))