Hello All,

Requesting help from expert excel users. I am a newbie and learning excel functions and infact this is my first post in the forum.

My query is how do i highlight the first and second duplicate entry in a column. What I am trying to do is making entries in a column. I want that whenever the first and the second duplicate entry occurs, the cell should be highlighted with a colour. Both with different colours. Example the first occurence with green and second occurence with maybe blue.

Thanking you in advance for all the help.