Highlight each first unique entry in a list

[SmiggyG]

Hi,

I have a list that has a number of dipliacte entries:

List
A1 1*
A2 1
A3 etc. 1
2*
2
2
3*
3
3

I need a formula (or conditional format) that will
highlight the first of each unique value in the list (
i.e. the entries marked *)


Can anyone help?

 

[Paul]

Hi,

I have a list that has a number of dipliacte entries:

List
A1 1*
A2 1
A3 etc. 1
2*
2
2
3*
3
3

I need a formula (or conditional format) that will
highlight the first of each unique value in the list (
i.e. the entries marked *)


Can anyone help?

Select cells A2 downwards and conditionally format using the formula
=(A2<>A1)
(A1 could be permanently formatted to match.)