How do I highlight duplicated data

[ghrek]

Hi

I have a sheet that im trying to highlight duplicated entries.

What I need to do is look down the whole sheet and if in columns B-E have duplicated entries across the row I need one of them deleting and the other remaining in the sheet.

What I mean by duplicated entries across the row is the data in lets say row 14 columns B-E and also row 25 columns B-E are an exact match then I need one of the rows deleting and other have the word "DUPLICATE" input in column F.

Any Ideas?

 

[DanteAmor]

In your example, which row do you want to delete 14 or 25?
And what should the macro do if it has more than 2 duplicate rows?