Forum Discussion

duco gm mansvelder's avatar
duco gm mansvelder
Copper Contributor
Nov 17, 2018

conditional formatting based on formula description

Hi there, 

 

I am trying to arrange conditional formatting based on the text of a formula in a cell. The base formule is:

 

=SEARCH("'[";FORMULATEXT(C22);2) / (=VIND.SPEC("'[";FORMULETEKST(C22);2))

So when a formula in cell c22 has the text [' in it, than i want it (conditionaly) formatted.

 

With an if construction as: 

=IFERROR(SEARCH("'[";FORMULATEXT(C22);2)=2;1) /

=ALS.FOUT(VIND.SPEC("'[";FORMULETEKST(C22);2)=2;1)

 

I thought to succeed but i can get it working in condional formatting

 

Basically i want to see (by the formating of the cell) if the value in the cell is a reference to another excel or not.

 

How do i get this formule in a conditional formating format? Or is there a better way to solve this problem?

 

Regards,

DM

 

 

Conditional Formatting
    • duco gm mansvelder's avatar
      duco gm mansvelder
      Copper Contributor
      Nov 17, 2018
      Hi Sergei, Thanks. It works. By the way, i want to copy this conditional formatting formula to all the cells in te spreadsheet. Is there probably a better way to arrange this?
      • SergeiBaklan's avatar
        SergeiBaklan
        MVP
        Nov 17, 2018

        Duco, you are welcome. Don't copy, just apply to your entire sheet. If that's actually full sheet, not the range, apply the rule to

        =$1:$1048576

        and change in formula the cell reference on A1.

         

Resources