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]

As I haven't received any response for the above query, I have shared the same in another forum.
Once the link is reviewed and posted I will share the link.

 

[Peter_SSs]

Yes, please post the link

 

[RAJESH1960]

Yes, please post the link

Excel Ask & Answer | Facebook

 

[Peter_SSs]

Please post links to all cross-posts.

 

[RAJESH1960]

Conditional formatting with condition
This is new to me. If I come across a solution, I will surely share that but sharing all the cross posts, I don't know how it will help. Whatever, rules are to be followed. So, once again I have posted the next link.
If I don't get the solution, maybe I will keep posting in different forums till I find a solution and will share those links too here without fail. Sorry Once again.

 

[Peter_SSs]

I don't know how it will help.

If you followed & read the link at the end of the rule you have been directed to several times - see below - then you would know the answer to that.

This is new to me.

It shouldn't be new to you ..
Get data from online with code
Set the number of rows for the FormulaArray
Buttons on top of other
(there are more)

In fact, given the number of times this has happened, be aware that should it happen again, you will likely find your account banned.
Note that I am not saying that you cannot cross-post. It is just that if you do, you must provide links to all such posts.

 

[RAJESH1960]

must provide links to all such posts.

Noted sir.

 

[RAJESH1960]

color rows with almost same amount which appear more than twice with CF - OzGrid Free Excel/VBA Help Forum
shared once again as solution to the query is still pending.

 

[RAJESH1960]

This is to inform you that if it possible to write a code that too will help.