Mark duplicate record list from sheet1 to sheet 2

[denuxer]

I want to highlights the data record in sheet 1 that match in sheet 2

DATA in sheet1

NAME	YEAR	MONTH	TOWN
BOY	2000	12	BALI
BOYS	2000	12	JAKARTA
CULL	2001	08	SURABAYA
NIT	2003	03	PALU

data in sheet2

NAME	YEAR	MONTH	TOWN
BOY	2000	12	BALI
BOY	2001	12	JAKARTA
CULL	2001	08	SURABAYA
CULL	2001	09	PALU

how can automaticaly highlight the data that match in column Name and Year and Month

excell.PNG

[boopathiraja]

Hi, Refer the file with conditional formating, edit the ranges as per your req

[denuxer]

Thank you so much
its works

can we delete all record that we have mark with colour before automaticaly??
+ rep for you

[boopathiraja]

Hi, Just filter for true and del... & Thanks for the rep

[denuxer]

Hi, Just filter for true and del... & Thanks for the rep

thanks again.. you are amazing..