I'd like a formula that highlights all duplicate cells, even if they are in different columns.

In my example spreadsheet A1 is equal to D15, the formula should highlight both, and so on with all worksheet duplicates, regardless of whether or not in the same column.

What would I have to do to accomplish that?

  • 3
    I found a decent problem description in the spreadsheet. I have edited that into the question. Commented Dec 11, 2015 at 9:11

2 Answers 2


One way to accomplish this is to use conditional formatting in each cell, having it trigger with the custom formula =EXACT({cellA},{cellB}).


I would use a custom formula on conditional formatting such as:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.