I need to be able to show any duplicates in a list it will look like this

A B C D

ROAD NAME NUMBER STATUS NUMBER OF TIMES APPEARED

I need to highlight the duplicates so that if a road name and a house in
that road keeps appearing with the same status will be either (Yes or no) i
can have in a column the number of times it has appeared and maybe highlight
its latest entry in a colour so for example Gerald Road No:14 appears for the
third time the latest entry has 3 in red in the D column. Ideally as they
type it in it will show them then.

This really has me stumped i have been looking at other macros or formulas
but i am still stuck
Many Thanks for looking