Forum Discussion

Copper Contributor

Nov 17, 2018

Solved

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...

Conditional Formatting

SergeiBaklan
Nov 17, 2018
Hi Duco,

That could be

=ISNUMBER(SEARCH("[",FORMULATEXT(C22)))

for the English locale, you may convert to your locale here https://en.excel-translator.de/translator/

SergeiBaklan

MVP

Nov 17, 2018

Hi Duco,

That could be

=ISNUMBER(SEARCH("[",FORMULATEXT(C22)))

for the English locale, you may convert to your locale here https://en.excel-translator.de/translator/

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
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.