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

  • Please post links to ALL cross posts.

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

  • AliGW

    Added the Label Cross Post
  • 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.

  • There are still missing links - there are other forums where this has been psoted. Please share ALL cross-post links.

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

  • The query has been solved.

    Code
    =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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!