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:
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?
View best response
That could be
for the English locale, you may convert to your locale here https://en.excel-translator.de/translator/
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
and change in formula the cell reference on A1.