Anbuselvam K
Member
Dear Excel Genius
In the below values, Many Names and F1 to F6 are repeated and duplicates exist. But I want to highlight the duplicates with both the columns, not just in one.
For Example, Anbu F1 is the real duplicates, but if I apply Conditional Formates to find the duplicates, it highlights all the names and F1 to F6 as it is compared values in one column only.
Finally, I want to highlight 1st and 7th-row values as duplicates. Please suggest the way to get the same.
In the below values, Many Names and F1 to F6 are repeated and duplicates exist. But I want to highlight the duplicates with both the columns, not just in one.
For Example, Anbu F1 is the real duplicates, but if I apply Conditional Formates to find the duplicates, it highlights all the names and F1 to F6 as it is compared values in one column only.
Finally, I want to highlight 1st and 7th-row values as duplicates. Please suggest the way to get the same.