CODEWITHSUNDEEP
google-sheetsconditional-statementsmatcharray-formulasconditional-formatting
alsanmph
alsanmph

Reputation: 93

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?

Upvotes: 2

Views: 59

Answers (1)

player0
player0

Reputation: 1

to highlight formula you can use

=ISFORMULA(A1)

to highlight only arrayformula formulas you can do:

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

Upvotes: 0

Related Questions