Detect duplicate values in DIFFERENT sheets

[A.Rahman]

Hi,

As the title says, I have been working in sheets of emails.
And I need to detect any duplicate email across the 3 sheets that I have.
I was able to do that across one sheet, but I could not find a way for 3 of them.

I hope you would help me out.

Thank you in advance.

[Special-K]

Not saying I'll answer this but you haven't provided any description of the layout of the sheets.

Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.

[A.Rahman]

Sorry for that, an example is attached now.

To clarify what I need:
Any email that is found in one of the sheets more than once, they need to be highlighted.