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 change colour example:

=Binders$c$4 - I want all the cell's that has the word "Binders" contained in their formula to go Blue

=Cars$D$5 - I want all the cell's with the word "Cars" contained in their formula to go Green.

 

Is this possible?

Formulas and Functions

2 Replies

Sort By
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    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)))

     

Resources