Move duplicates to new sheet & High lighting remaining similarities

[Sharid]

I have a list of URLS and emails in columns D and E. I don't want to use the excel find duplicates as it deletes all duplicates, where as I want them moved to another sheet.

Also if there are similarities then I want it to highlight the text in Orange.

See below

From this
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Emails
[/TD]
[TD="align: center"]URLS
[/TD]
[/TR]
[TR]
[TD]jon@mysite.com
[/TD]
[TD]https://www.mysite.com/
[/TD]
[/TR]
[TR]
[TD]Jon@mysite.com
[/TD]
[TD]https://www.mysite.com/[/TD]
[/TR]
[TR]
[TD]Jane@mysite.com
[/TD]
[TD]https://www.mysite.com/[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]https://www.mysite.com/[/TD]
[/TR]
[TR]
[TD]Jane@mysite.com
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Peter@yoursite.com
[/TD]
[TD]https://www.Yoursite.com/
[/TD]
[/TR]
[TR]
[TD]Jack@yoursite.com
[/TD]
[TD]https://www.Yoursite.com/
[/TD]
[/TR]
[TR]
[TD]peter@yoursite.com
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]peter@yoursite.com
[/TD]
[TD]https://www.Yoursite.com/[/TD]
[/TR]
[TR]
[TD]Jane@heresite.com
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


To this

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Emails
[/TD]
[TD]URLS
[/TD]
[/TR]
[TR]
[TD]jon@mysite.com[/TD]
[TD]https://www.mysite.com/
[/TD]
[/TR]
[TR]
[TD]Jane@mysite.com
[/TD]
[TD]https://www.mysite.com/
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]https://www.mysite.com/
[/TD]
[/TR]
[TR]
[TD]Jane@mysite.com
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Peter@yoursite.com
[/TD]
[TD]https://www.Yoursite.com/
[/TD]
[/TR]
[TR]
[TD]Jack@yoursite.com
[/TD]
[TD]https://www.Yoursite.com/
[/TD]
[/TR]
[TR]
[TD]Peter@yoursite.com
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Jane@heresite.com[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

All duplicates have been moved to sheet2 and all similarities have been identified, the similarities must be an exsact match but NOT case senstive

Thanks