How can i find matching value between 2 columns and highlight them?
Lets say that i want to know if a value in Column A has a matching cell in Column B.
Would also like to have it highlighted.
Any idea how to do that?
If you just want a way to indicate a match this will report the row number of the matching value from B in column C:
The formula in C2, copied down the column:
=IFERROR(MATCH(A2,B,0),"")
If you must highlight the cells in column A that have a match in column B you could do this:
When there is a match this places the value in column A in column C as well. Then you can use Conditional Highlighting:
That cell reference (C2 in the example) is entered by first clicking the symbol that looks like an arrow pointing at a box then clicking cell C2.
SG