Conditional Formatting not working

[CA_Punit]

So i am trying to drag rate from column A for which values from column B are greater than zero and trying to match with Rate (Data) from column A with Column Q . Since Q has more alphabet than column A so i have used "*" to find the partial match

Say for example ABF from Column A is available as ABF1, ABF3 ABFAN etc etc from column Q.

It is for a different threat on which i am working and the user is only using office 2013. I have created a formula which gives me true and false in column M and is perfect. But it is not working in conditional formatting

please find this

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Rate	Available
2	A	0											FALSE				ABE2
3	ABF	5											FALSE				ABE3
4	AC	0											FALSE				ABEAN
5	ADEK	0											FALSE				ABECS
6	AE	0											TRUE				ABF1
7	AG	0											TRUE				ABF3
8	AIRR	0											TRUE				ABFAN
9	AME	0											TRUE				ABFAN
10	AN	0											TRUE				ABFC
11	AS	0											TRUE				ABFFAN
12	AV	0											FALSE				ABH1
13	AWF	0											FALSE				ABH2
14	AWR	0											FALSE				ABH3
15	AZ	30											FALSE				ABHAN
16	BU	0											FALSE				ABHC
17	CM	0											FALSE				AC2
18	CSS	0											FALSE				ACCS
19	CTM	0											FALSE				AD2
20	CTR	456											FALSE				AD3
21	DC	0											FALSE				ADAN
22	EA	0											FALSE				AE1
23	EMN	0
24	EO	0
25	ET	0
26	ETR	0
27	FC	0
28	FN	0
29	GM	45
30	GSM	0
31	HMBHT	0
32	HMDH	0
33	HML	0
34	IC	0
35	IT	0
36	LN	0
37	LSS	0
38	MC	0
39	MMA	0
40	MMS	0
41	MN	54
42	MT	0
43	NC	0
44	NUC	0
45	PC	0
46	PS	0
47	RP	0
48	S	0
49	SECF	0
50	SH	0
51	SKS	0
52	SNL	0
53	STG	0
54	SW	0
55	UT	0
Sheet5

Cell Formulas
Range	Formula
M2:M22	M2	=SUM(IFERROR(SEARCH(INDEX(INDEX($A$2:$A$55,AGGREGATE(14,6,1/(1/(ISERROR(IF($B$2:$B$55>0,$A$2:$A$55)*(ROW($A$2:$A$55)-ROW($A$2)+1))*(ROW($A$2:$A$55)-ROW($A$2)+1))),(ROW($A$2:$A$55)-ROW($A$2)+1))),ROW(INDIRECT("A1:A"&COUNTA($A$2:$A$55)-SUM(--ISERROR(INDEX($A$2:$A$55,AGGREGATE(14,6,1/(1/(ISERROR(IF($B$2:$B$55>0,$A$2:$A$55)*(ROW($A$2:$A$55)-ROW($A$2)+1))*(ROW($A$2:$A$55)-ROW($A$2)+1))),(ROW($A$2:$A$55)-ROW($A$2)+1))))))))&"*",$Q2),0))>0

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
Q2:Q149	Expression	=SUM(IFERROR(SEARCH(INDEX(INDEX($A$2:$A$55,AGGREGATE(14,6,1/(1/(ISERROR(IF($B$2:$B$55>0,$A$2:$A$55)*(ROW($A$2:$A$55)-ROW($A$2)+1))*(ROW($A$2:$A$55)-ROW($A$2)+1))),(ROW($A$2:$A$55)-ROW($A$2)+1))),ROW(INDIRECT("A1:A"&COUNTA($A$2:$A$55)-SUM(--ISERROR(INDEX($A$2:$A$55,AGGREGATE(14,6,1/(1/(ISERROR(IF($B$2:$B$55>0,$A$2:$A$55)*(ROW($A$2:$A$55)-ROW($A$2)+1))*(ROW($A$2:$A$55)-ROW($A$2)+1))),(ROW($A$2:$A$55)-ROW($A$2)+1))))))))&"*",$Q2),0))>0	text	NO

 

[Fluff]

As this is basically a duplicate closed, I am closing it.
Please do not start threads to help other members.