how to highlight on excel? I have names listed in column A. Most names are duplicates. Column H contains text. I need to highlight rows that have duplicate values in A (same name) and also contain duplicate values in Column H for those rows with the same name in A. Technically, all H values should be unique for that person. So, I want to identify H values that are duplicate for that person only.
Solved by K. S. in 23 mins