Is it possible to use conditional formatting in Google Sheets to only format cells that are formulas (i.e. begin with an = sign)? For example, I would like a cell containing =F2*30
to be highlighted while a cell containing 150
would not be highlighted.
1 Answer
Use this conditional formatting custom formula rule for the range A1:Z
:
=isformula(A1)