u/-MrJester

Hey everyone, I'm trying to highlight a word in one column in a sheet that is also in a column in another sheet. For example I'm trying to highlight the word "Apple" in column B in sheet "common" as it's also in in column B in sheet "Test".

I looked around and I read that I should put a custom formula in conditional formatting with the most common formula seemingly being:

=COUNTIF(INDIRECT("Test!B:B"),B2)>0

https://preview.redd.it/ulz9opoowxjh1.png?width=308&format=png&auto=webp&s=143a619bd3a2e3e1ade592521c72e8fc628f0ed3

However it's giving me false positives in the column B of sheet common. It's highlighting a vast amounts of cells that aren't in column B of sheet test.

Does anyone have an idea what I could do amend that?

Thanks in advance for any help!