Google-sheets – Conditional Format if cell in one column contains partial match from another column-CodePudding

Home > Net > Google-sheets – Conditional Format if cell in one column contains partial match from another column

Google-sheets – Conditional Format if cell in one column contains partial match from another column

Time：12-09

I am trying to find a custom formula to highlight a cell from one column (A) if it contains a partial text from another column (C)

I created a sample spreadsheet:

CodePudding user response：

You can also try with this, it joins the whole C column and matches with REGEXMATCH. The second parenthesis excludes when the cell is empty:

=REGEXMATCH(JOIN(",",C:C),A1)*(A1<>"")