I have a list of values in column A named "Our Keywords" and another list of values from multiple columns from competitors named "Competitor keywords"
Using conditional formatting, how can I highlight the keywords that appear in "Competitor keyword" columns but not in "Our keywords" column. And vice versa keywords that are unique to the "our keywords" column.
e.g. problem:
e.g. desired result:
The words that appear in column 1 ONLY are highlighted green and words that appear in the competitor columns but NOT in column 1 are highlighted red.
green color:
=FILTER(A1, NOT(COUNTIF(B1:E, A1)))
red color:
=FILTER(B1, NOT(COUNTIF(A$1:A, B1)))
=FILTER(C1, NOT(COUNTIF(A$1:A, C1)))
=FILTER(D1, NOT(COUNTIF(A$1:A, D1)))