color rows with almost same amount which appear more than twice with CF

MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

Hello guys
I have shared this query in more than one forum but I haven't received any solution.
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 expertise to know what formula should I enter in the conditional formatting new rule.
I have colored the cells yellow to show the expected result.

Thank you in advance.

test CF.xlsx

link to one of the forums where I have tried to find a solution,

Conditional formatting with condition

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…

www.mrexcel.com

Conditional formatting with condition

Shared in these forums

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.

You are mistaken. I have shared all the 3 links where I have shared this post.

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