As per your sample
in cell D2
then you can use the following formula in Conditional Formatting to highlight only the first occurrence of an entry in the list.
=IF(COUNTIF($E$2:$E$14,E2)=1,FALSE,COUNTIF($E$2:E2,E2)=1)
or
You can also do the reverse of this with Conditional Formatting. Using the formula below in Conditional Formatting will highlight only the second and subsequent occurrences of a value. The first occurrence of the value will not be highlighted.
=IF(COUNTIF($E$2:$E$14,E2)=1,FALSE,NOT(COUNTIF($E$2:E2,E2)=1))
Bookmarks