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. [TABLE="width: 500"]
<tbody>[TR]
[TD]James[/TD]
[TD]Linda[/TD]
[TD]Peggy[/TD]
[TD]Lisa[/TD]
[TD]Paula[/TD]
[/TR]
[TR]
[TD]Karen[/TD]
[TD]George[/TD]
[TD]Sara[/TD]
[TD]James[/TD]
[TD]Mike[/TD]
[/TR]
[TR]
[TD]Mike[/TD]
[TD]James[/TD]
[TD]Tom[/TD]
[TD]Karen[/TD]
[TD]Carrie[/TD]
[/TR]
[TR]
[TD]Tom[/TD]
[TD]Carrie[/TD]
[TD]Mike[/TD]
[TD]Sam[/TD]
[TD]George[/TD]
[/TR]
</tbody>[/TABLE]
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. [TABLE="width: 500"]
<tbody>[TR]
[TD]James[/TD]
[TD]Linda[/TD]
[TD]Peggy[/TD]
[TD]Lisa[/TD]
[TD]Paula[/TD]
[/TR]
[TR]
[TD]Karen[/TD]
[TD]George[/TD]
[TD]Sara[/TD]
[TD]James[/TD]
[TD]Mike[/TD]
[/TR]
[TR]
[TD]Mike[/TD]
[TD]James[/TD]
[TD]Tom[/TD]
[TD]Karen[/TD]
[TD]Carrie[/TD]
[/TR]
[TR]
[TD]Tom[/TD]
[TD]Carrie[/TD]
[TD]Mike[/TD]
[TD]Sam[/TD]
[TD]George[/TD]
[/TR]
</tbody>[/TABLE]
Any suggestions would be great.