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.
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
Add a comment
|
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))
answered Jul 9 '19 at 16:00
-
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
-
-
1That's very true :) @ScottCraner, you awefully good at these things (in a good way) – JvdV Jul 9 '19 at 16:19
