Forum Discussion
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...
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/
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?
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.
