Conditional formatting to color amounts appearing more than twice with condition

[RAJESH1960]

Hello guys
Using conditional formatting, I am trying to color the amounts which appear more than twice for each name. Sometimes the amounts are the same in 2 or more different names. The problem is the formula colors all the cells. I want to add a condition in the formula. The color should be applied at each change in name. But I don't know how to select the range in this case.

Nabeel new.xlsx
	A	B
1	Name	Amount
2	April	8379.00
3	April	9730.00
4	April	9730.00
5	April	10000.00
6	April	10000.00
7	April	10000.00
8	April	10500.00
9	April	10500.00
10	April	10500.00
11	April	15077.00
12	April	15077.00
13	April	4165.00
14	August	3596.00
15	August	4165.00
16	August	4165.00
17	August	4165.00
18	August	4582.00
19	August	4582.00
20	August	4582.00
21	August	4582.00
22	August	5117.00
23	August	5117.00
24	August	5800.00
25	August	5800.00
26	August	5800.00
27	August	5800.00
28	August	5950.00
29	August	5950.00
30	August	6160.00
31	August	6160.00
32	August	6160.00
33	August	6160.00
34	August	10000.00
35	August	10000.00
36	August	10500.00
37	August	10500.00
38	August	10500.00
39	August	11000.00
40	August	11500.00
41	August	11500.00
42	August	11500.00
43	August	11500.00
44	August	11500.00
45	August	120210.00
46	December	10000.00
47	December	10000.00
48	December	10000.00
49	December	10000.00
50	December	10500.00
51	December	10500.00
52	December	11500.00
53	December	11500.00
54	December	11500.00
55	December	11500.00
56	December	12500.00
57	December	12500.00
58	December	12500.00
59	December	12500.00
60	December	12500.00
61	December	12500.00
62	DEEPAK	10000.00
63	DEEPAK	10000.00
64	DEEPIKA	10000.00
65	DEEPIKA	10000.00
66	DEEPIKA	11500.00
67	DEEPIKA	11500.00
68	DELHI	10000.00
69	DELHI	10000.00
70	FAB	344246.00
71	FAB	344246.00
72	February	10500.00
73	February	10500.00
74	February	10500.00
75	February	10500.00
76	FEELINGS	430.00
77	FLIPKART	12811.22
78	FLIPKART	16472.86
79	FLIPKART	20054.15
80	FLIPKART	23086.97
81	January	10000.00
82	January	10000.00
83	July	6244.00
84	July	6395.00
85	July	8888.00
86	July	8898.23
87	July	9071.00
88	July	9082.00
89	July	9125.00
90	July	10000.00
91	July	10000.00
92	July	10500.00
93	July	10500.00
94	July	10500.00
95	July	10500.00
96	July	11000.00
97	July	11000.00
98	July	11000.00
99	July	11000.00
100	July	32146.00
101	July	32146.00
102	July	32146.00
103	July	32146.00
104	June	1050.00
105	June	10000.00
106	June	10000.00
107	June	10500.00
108	June	10500.00
109	June	10500.00
110	June	11000.00
111	June	11000.00
112	June	11000.00
113	June	11000.00
114	June	24806.00
115	June	27896.00
116	June	27896.00
117	June	30403.00
118	June	30403.00
119	June	32146.00
120	June	32146.00
121	March	10500.00
122	March	10500.00
123	May	8379.00
124	May	8379.00
125	May	8379.00
126	May	8379.00
127	May	10000.00
128	May	10000.00
129	May	10000.00
130	May	10000.00
131	May	10000.00
132	May	10000.00
133	May	17136.00
134	May	17136.00
135	May	17696.00
136	May	18771.00
137	May	23625.00
138	May	28350.00
139	May	30822.00
140	May	30822.00
141	May	30822.00
142	May	84840.00
143	May	84840.00
144	May	84840.00
145	November	2835.00
146	November	2835.00
147	November	3021.00
148	November	3021.00
149	November	4994.00
150	November	4994.06
151	November	10500.00
152	November	10500.00
153	November	11000.00
154	November	11000.00
155	November	11000.00
156	November	11000.00
157	November	12500.00
158	November	12500.00
159	November	13000.00
160	November	13000.00
161	November	13000.00
162	November	13000.00
163	November	13000.00
164	October	2835.00
165	October	2835.00
166	October	3021.00
167	October	3021.00
168	October	4994.00
169	October	4994.06
170	October	10500.00
171	October	10500.00
172	October	11000.00
173	October	11000.00
174	October	11000.00
175	October	11000.00
176	October	12500.00
177	October	12500.00
178	October	13000.00
179	October	13000.00
180	October	13000.00
181	October	13000.00
182	October	13000.00
183	September	10500.00
184	September	10500.00
185	September	11000.00
186	September	11000.00
187	September	11000.00
188	September	11000.00
189	September	12500.00
190	September	12500.00
191	September	13000.00
192	September	13000.00
193	September	13000.00
194	September	13000.00
195	September	13000.00
196	Sunday	10000.00
197	Sunday	10000.00
Color

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:B197	Expression	=COUNTIF($B$2:$B$200,$B2)>2	text	NO

 

[RAJESH1960]

The formula should check each name where the same amount appears more than twice only then it should color the row.
Like in April 10000 appears more than twice and in August it appears only twice. So I need to color rows of April containing 10000 only and not August and so on.......

 

[Peter_SSs]

Try this formula instead

=COUNTIFS(B$2:B$200,B2,A$2:A$200,A2)>2

 

[RAJESH1960]

Try this formula instead

=COUNTIFS(B$2:B$200,B2,A$2:A$200,A2)>2

It's perfect. Thanks Peter_SSs

 

[Peter_SSs]

You're welcome.