Conditional formatting with condition

[RAJESH1960]

Hello guys
Column C is the ID No. I am trying to find under each ID No. how many entries are of the same value in G to L. If the difference between the same value is more or less than 1.00 then it should accept as same value. If the row count is more than 2 then I want to color all the 3 rows using conditional formatting. I need your help to know what formula should I enter in the conditional formatting new rule.
I have colored the cells yellow to show the expected result.

test CF.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	A	B	ID No.	D	E	F	G	H	I	J	K	L	M	N
2	1		06AABCV3609C1ZR				47.50				950.00	950.00
3	2		06AABCV3609C1ZR				106.00				2120.00	2120.00
4	3		06ACXPN0601P1Z5				1399.50				29399.50	28000.00
5	4		06ACXPN0601P1Z5				1400.00				29400.00	28000.00
6	5		06ACXPN0601P1Z5				1400.00				29400.00	28000.00
7	6		06ACXPN0601P1Z5				1400.00				29400.00	28000.00
8	7		06AXFPA2657R1Z5				2656.80				24797.00	22140.00
9	8		06AUMPK7295D2ZA				2840.85				59657.85	56817.00
10	9		06AUMPK7295D2ZA				2840.85				59657.85	56817.00
11	#		06AUMPK7295D2ZA				2840.00				59657.00	56817.00
12	#		06AXFPA2657R1Z5				2656.80				24796.80	22140.00
13	#		06AXFPA2657R1Z5				4284.00				28084.00	23800.00
14	#		29AAACD1390F1ZU					6.56	6.56		86.01	72.89
15	#		29AAACP0165G1ZL					702.82	702.82		9214.64	7809.00
16	#		29AAACS9735K1ZR					39.50	39.50		1666.00	1587.00
17	#		29AAACS9735K1ZR					39.68	39.68		1666.36	1587.00
18	#		29AAACS9735K1ZR					39.68	39.68		1666.36	1587.00
19	#		29AAACS9735K1ZR					40.25	40.25		1690.50	1610.00
20	#		29AAACS9735K1ZR					672.75	672.75		28256.00	26910.00
21	#		29AAACS9735K1ZR					672.75	672.75		28255.50	26910.00
22	#		29AAACS9735K1ZR					672.50	672.50		28255.00	26910.00
23	#		29AABCG3246Q1Z4					221.18	221.19		2900.00	2457.63
Test CF

 

[RAJESH1960]

This is to inform you that the issue has not yet been resolved in any of the forums. If it is solved I will update this post without fail with the solution.

 

[RAJESH1960]

This is to inform you that the query has been solved.

=SUMPRODUCT(($C$2:$C$23=$C2)*($G$2:$G$23>$G2-1)*($G$2:$G$23<$G2+1)*($H$2:$H$23>$H2-1)*($H$2:$H$23<$H2+1)*($I$2:$I$23>$I2-1)*($I$2:$I$23<$I2+1))>2

 

[RAJESH1960]

@johnnyL . Please leave a message when you are online. I want to add the above formula in the code of Match Portal sheet with a few issues to solve.