1

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?

Improve this question
1
  • 3
    I found a decent problem description in the spreadsheet. I have edited that into the question.
    – Vidar S. Ramdal
    Commented Dec 11, 2015 at 9:11

2 Answers 2

Reset to default
2

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

Improve this answer
2

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

=COUNTIF($A:$E,A1)>1
Improve this answer

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.