Forum Discussion
Conditional Formatting - comparing rows of names
Hello,
I'm working on a very large spreadsheet and I need to figure out which names in one column are present in another. I would usually use the "highlight duplicates" conditional formatting for this but the column I'm looking at contains duplicates by nature!
I'm trying to write a formula to do the conditional formatting, I've tried MATCH and COUNTIF but I can't seem to get it right.
Any help much appreciated.
Chris
Christopher,
The below formula will return TRUE if a value is in Col1, and FALSE if it's not.
=ISNUMBER(MATCH(B2,$A$2:$A$7,0))
Also, I've used the Conditional Formatting to highlight each TRUE in Green and each FALSE in Red!
Hope that helps.
