Duplicates to cover all data in row

[surkdidat]

Good afternoon

I have data in columns A, B, C, D, E and G that I am after a formula (Conditional format?) - that will look at all rows in the sheet (say from Row 2 to Row 300) that will highlight any rows where the data is EXACTLY the same taking into account all cells in that row.. (See below, this example should be correct!!

Either a formula/conditional format should suffice. An alternative might be a macro that does it and auto deletes, but the former would be sufficient - thanks!)

	A	B	C	D	E	G
	IT5	1152625	359656595656	AAAAAAA	1	Grimsby
	IT5	1152625	359656595656	AAAAAAA	1	Grimsby
	IT5	1152625	359656595656	BBBBBBBB	1	Chesterfield
	IT5	1152625	359891575587	BBBBBBBB	1	Lincoln
	IT5	1152625	359891575587	BBBBBBBB	2	Salisbury
	IT5	1152625	359891575587	BBBBBBBB	2	Salisbury

 

[Joe4]

Will they always be sorted, so that the duplicates always appear in succession, as shown in your example?

If so, then you can just use a Conditional Formatting formula like (for row 2):

=AND(A2=A1,B2=B1,C2=C1,D2=D1,E2=E1,G2=G1)

Note that if you want to delete, a macro is not required.
Just use the built-in "Remove Duplicates" functionality.