Looking for First instance of item

[OcMac]

Hey all,

I know this one might seem easy, but I just can't seem to figure it out.

I would like to write code that takes a column of data, say names, look through that column and highlight/ fill the cell the first time the name appears.

Anyone ideas?

Thank you,

Matt

[dilipandey]

Hi Matt,

You can use a formula in conditional formatting to achieve this..

=countif($A$1:$a1,$a1)=1

see attachment:- first time occurrence - highlight.xlsx

Regards,
DILIPandey
<click on below * if this helps>

[OcMac]

Thank you very much, I totally forgot about that. It must be Friday here.

Now how do it tell it not to do row 1, that is a header row?

[dilipandey]

delete the conditional formatting from row 1


see attached:-first time occurrence - highlight.xlsx

Regards,
DILIPandey
<click on below * if this helps>