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 Commented Jul 9, 2019 at 15:51
  • I don't know the formula ... Trying to figure that out.
    – Abram
    Commented Jul 9, 2019 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
    Commented Jul 9, 2019 at 15:55
  • Picture added for clarity.
    – Abram
    Commented Jul 9, 2019 at 15:57

1 Answer 1

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
    Commented Jul 9, 2019 at 16:01
  • 1
    @Abram does not matter, the MATCH if one is found will return a number. Commented Jul 9, 2019 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
    Commented Jul 9, 2019 at 16:09
  • Column B formula applies to =$B:$B and the other to the other. Commented Jul 9, 2019 at 16:10
  • 1
    That's very true :) @ScottCraner, you awefully good at these things (in a good way)
    – JvdV
    Commented Jul 9, 2019 at 16:19

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .