Nov 17 2018 05:00 AM
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
Nov 17 2018 05:28 AM
SolutionHi 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/
Nov 17 2018 05:46 AM
Nov 17 2018 06:15 AM
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.
Nov 17 2018 05:28 AM
SolutionHi 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/