Search code examples
google-sheetsconditional-statementsmatcharray-formulasconditional-formatting

Conditional Formatting to cells that contain certain formula in Google Sheets

I want to highlight with conditional formatting the cells that contain ARRAYFORMULA (just the formula cell, not the whole array). How could be done?

Solution

  • to highlight formula you can use

    =ISFORMULA(A1)

    to highlight only arrayformula formulas you can do:

    =REGEXMATCH(FORMULATEXT(A1); "(?i)arrayformula")