Forum Discussion

Erica Visser's avatar
Erica Visser
Copper Contributor
Sep 23, 2018

Problem with conditional formatting?

Hi I am trying to set a conditional formatting based on the fact that a certain text or range name is found in a formula in the cell. So if my cell contains the following formula then I want it to ...
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Sep 23, 2018

Hi Erica,

 

I didn't catch which formulas do you have, but to check in conditional formatting rule if formula in the cell contains this or that text you may by

=ISNUMBER(SEARCH("MyText",FORMULATEXT(A1)))

 

  • Erica Visser's avatar
    Erica Visser
    Copper Contributor
    Sep 25, 2018
    Hi Sergei
    Thanks that is awesome.

Resources