Hello experts,
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.
=COUNTIFS(C$2:C$20000,C2,G$2:G$20000,G2,H$2:H$20000,H2,I$2:I$20000,I2)>2
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.
https://www.mrexcel.com/board/thread...ition.1212126/
Bookmarks