Does anybody know why this example's FIND function doesn't treat cases differently? The conditional formatting command
was used on my table. And because FIND is case-sensitive, the word "Rektor" in column B causes the term "Prorektor" to be coloured in column A, even though it shouldn't, or did I do it wrong?
Also, if anybody knows why the first cell of my array seems to stay unaffected by the formula, I'd be happy to hear it! I'm using Excel Version 2301.