I have posted this query in different forums and I am not able to solve it though. I am trying to color the rows where the amounts are repeated more than twice under one ID No. I am not even able to get the first condition of the 2 conditions right.
I tried and entered this formula in the new rule to get the first condition right but it seems I am missing something.
The second condition is that it should accept the amounts where the difference is less than 1/- between the same amounts under one ID No. like in the workbook.
The Link to the same query in the other forum.