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?

0
0
  • 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

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