CODEWITHSUNDEEP
excel
Shakeer Hussain
Shakeer Hussain

Reputation: 2536

I need to find duplicates from two different columns in an excel but it should ignore duplicates in same column

I have data in two different columns ColA and ColB in Excel. I want to highlight ColA if there is a duplicate found in ColB and I want to avoid highlighting if duplicate record is found in same column which is ColA. I am using Conditional Formatting - Highlight cell rules - Duplicate Values.

Upvotes: 0

Views: 65

Answers (1)

Ron Rosenfeld
Ron Rosenfeld

Reputation: 60224

You need to use a formula for your conditional formatting.

eg:

If this is what you expect:
enter image description here

then the conditional format formula would be:

=ISNUMBER(MATCH($A1,$B$1:$B$6,0))

enter image description here

Upvotes: 0

Related Questions