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
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.
link to one of the forums where I have tried to find a solution,