Forum Discussion
Anonymous
Mar 01, 2018Conditional 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 f...
Haytham Amairah
Mar 02, 2018Silver Contributor
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.