0In Column “C”, I have product list and some of them are duplicates. My requirement is to format with background color of green for 1st found value among the duplicates. To solve this, I used formula in Conditional formatting. Check the below formula & screenshot.
Formula in Conditional Formatting is: =COUNTIFS($C$2:C2,C2)=1
Note: In the above formula if you write 2 instead of 1 then it will highlight 2nd duplicate value.
