0

I want to highlight cells in column A and column B where the cell in column A matches any cell in column B. Cell contents are strings, not numbers.

enter image description here

4
  • Use Conditional Formatting – Scott Craner Jul 9 '19 at 15:51
  • I don't know the formula ... Trying to figure that out. – Abram Jul 9 '19 at 15:53
  • Most of the online tutorials just show how to look for a match across columns for two cells that are on the same row ... – Abram Jul 9 '19 at 15:55
  • Picture added for clarity. – Abram Jul 9 '19 at 15:57
2

Use two Conditional Formatting rules, one for Column A and the other for Column B

Column A:

=ISNUMBER(MATCH(A1,B:B,0))

Column B:

=ISNUMBER(MATCH(B1,A:A,0))

enter image description here

10
  • I should have specified, the numbers in my example don't represent what's in my actual spreadsheet. I have email addresses. – Abram Jul 9 '19 at 16:01
  • 1
    @Abram does not matter, the MATCH if one is found will return a number. – Scott Craner Jul 9 '19 at 16:03
  • Any chance you can expand the rule in the conditional formatting rules manager. The Applies to part is confusing me, and I'm afraid I have it backwards. – Abram Jul 9 '19 at 16:09
  • Column B formula applies to =$B:$B and the other to the other. – Scott Craner Jul 9 '19 at 16:10
  • 1
    That's very true :) @ScottCraner, you awefully good at these things (in a good way) – JvdV Jul 9 '19 at 16:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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