Hi Experts,
This is a follow up from my previous thread https://www.excelforum.com/excel-gen...ml#post5776804 and I was doing some experiment with it to highlight the numbers in Number2 Column by using the formula =INDEX($D$2:$D$1000,MATCH($F2&G2,$B$2:$B$1000&$C$2:$C$1000,0))>0 in conditional formatting.
Number1 Number2 Frequency
2 60 1
2 54 2
2 34 2
2 22 1
2 32 1
2 42 1
2 40 3
2 36 1
2 48 1
2 44 1
2 28 1
2 30 2
2 24 1
2 58 1
2 26 2
2 56 1
2 52 2
2 38 1
2 46 1
2 50 1
But there's some error as boxed in red below which they shouldn't be highlighted. Pls advise if it's the equation in the conditional formatting which is wrong resulting in this happening and if yes, pls help to resolve this by providing the correct equation. Thanks.
1.png
Bookmarks