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?

  • Yes with conditional formatting and custom formula using MATCH or COUNTIF Dec 28, 2017 at 15:37

1 Answer 1


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

enter image description here

  • 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.