I am having trouble getting my conditional formatting to work. I am trying to highlight the first occurrence of value in a range of D19:I137.
I tried condition formatting duplicate value and it changed all occurrences to the same color. I also tried entering a formula but still can't get it to work.
I would like the first occurrence of a name to be in red and any duplicates in black.
<tbody>
</tbody>
Any suggestions would be great.
I tried condition formatting duplicate value and it changed all occurrences to the same color. I also tried entering a formula but still can't get it to work.
I would like the first occurrence of a name to be in red and any duplicates in black.
James | Linda | Peggy | Lisa | Paula |
Karen | George | Sara | James | Mike |
Mike | James | Tom | Karen | Carrie |
Tom | Carrie | Mike | Sam | George |
<tbody>
</tbody>
Any suggestions would be great.