Highlight each first unique entry in a list

  • Thread starter Thread starter SmiggyG
  • Start date Start date
S

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?
 
SmiggyG said:
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?
Click to expand...

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