0

I have data in google sheet. I want a way to cross match if values in column 1 is available on any row in column 2. If available either highlight with any colour or just bold it.

Is this possible on google sheets or MS Excel?

Improve this question
1
  • Yes with conditional formatting and custom formula using MATCH or COUNTIF
    – Scott Craner
    Dec 28, 2017 at 15:37

1 Answer 1

Reset to default
1

=IF(ISNA(MATCH($C1,$A$1:$A$8, 0)), "No Match", "Match")

enter image description here

Improve this answer
1
  • No worries. Make sure you post a copy of your spreadsheet next time to make answering the question easier! Cheers
    – Chef1075
    Dec 30, 2017 at 22:08

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .