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 1


Use this conditional formatting custom formula rule for the range A1:Z:


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