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?
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?
Yes with conditional formatting and custom formula using MATCH or COUNTIF – Scott Craner – 2017-12-28T15:37:16.220