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

CodePudding user response：

To highlight formula you can use

=ISFORMULA(A1)

To highlight only arrayformula formulas you can do:

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