Highlight Duplicate rows including first one
I have a requirement to highlight rows with duplicate line items in a Module. I have tried using the ISFIRSTOCCURRENCE along with conditional formatting but was only able to highlight the 2nd duplicate row. I am using Concatenation to check duplicates within a unique key of 4 line items.
Would be great if someone can help with this.