Hello,

I have two columns. Column one identifies a customer. Column two identifies an order. I would like conditional formatting which highlights the instances where there are multiple instances of orders from the same customer. I was able to create COUNTIF(A:A,A2)1 to find duplicates in column one and I thought, since it works out to TRUE or FALSE (1,0), I could use this feature in an IF. So I wrote =(IF(COUNTIF(A:A,A2)1*B20,1,0)) and got stuck. Clearly that does not work in any way.

I am out of my depth and would appreciate one of you gurus setting me straight. Thank you.



1524526 3049099
1524526 3049056
1524526 3049057
1524526 3049098
1524526 3049058
1524526 3049059
1524526 3049064
1524526 3049060
1524526 3049065
1524526 3049061
1524526 3049062
1524526 3049063
1524527 3049064
1524528 3049065
1524528 3049066
1524529 3049067
1524530 3049068
1524530 3049069
1524531 3049070