0

Is there a way, in Google Sheets, to have conditional formatting of some sort, to change the background color of a cell based on whether the cell contains a formula or a plain value?

Improve this question
0

1 Answer 1

Reset to default
1

  • red color for not formula & not empty:

    =(NOT(ISFORMULA(B1)))*(B1<>"")

    0

  • yellow color for the formula detection:

    =ISFORMULA(B1)

    0

  • bonus fact - showing a formula as text string:

    =FORMULATEXT(B2)

    0

Improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.