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?
user3550203
Posted 2017-12-28T15:32:42.693
Reputation: 103
1
=IF(ISNA(MATCH($C1,$A$1:$A$8, 0)), "No Match", "Match")
Chef1075
Posted 2017-12-28T15:32:42.693
Reputation: 160
Wow this works great @Chef, thanks a million :) – user3550203 – 2017-12-30T22:06:01.700
No worries. Make sure you post a copy of your spreadsheet next time to make answering the question easier! Cheers – Chef1075 – 2017-12-30T22:08:30.770
Yes with conditional formatting and custom formula using MATCH or COUNTIF – Scott Craner – 2017-12-28T15:37:16.220