excelexcel-formulaconditional-formattingtext-search

Excel - FIND function (case-sensitive) ignores case?

Does anybody happen to know why the FIND function isn't case-sensitive here:

I used conditional formatting on my table with =OR(ISNUMBER(FIND($B$1:$B$13,A1))). And the word "Rektor" in column B leads to a coloring of "Prorektor" in column A, even though it shouldn't if FIND is case-sensitive, or did I understand something wrong there?

enter image description here

Also, if anybody has an idea 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.

Many thanks!

Solved with the help of Solar Mike's comment:

The formula needs the ,1 in the FIND() function: =OR(ISNUMBER(FIND($B$1:$B$13,A1,1))) It works perfectly like this, finding all the correct fields.

Also perhaps helpful: I think for newer Excel versions it's ; instead of , in the formulas.

Solution

  • Just to show the behaviour of find():

    enter image description here