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")
Edit: But first set apply to range to: 1:1000