VBA Code to highlight duplicate

Hi Team,
I have a data in column B that is sorted in order e.g. Apple, Apple, Apple, Orange, Orange, Orange, Mango, Mango Mango...
I need a VBA code where the [B]last[B] duplicate is highlighted.

I was trying to find a simple formula to for example put a '1' in column A next to the last duplicate in column B but i couldn't find a formula, so I resulted in trying to do a VBA code instead..

you can do with functions yes but you will want *findnext* and *find*. then you go through range from top to bottom and get the value of each cell when you are checking it. the way you highlight last cell is put value in for *cell.interior* if *findnext* returns nothing. nothing means that you are at last cell with that value, and it was not found again all the way down the column.