I'm trying to write a fomula that will look in column A for any text that
contains the text "LOA". If TRUE, I want to apply some conditional formatting
to a range of cells. I tried the following formula when A4 = "loa" and it
still comes up TRUE. Any suggestions?

=ISNUMBER(SEARCH(UPPER("LOA"),A4))

Try this:

=ISNUMBER(FIND("LOA",UPPER(A4),1))

- AG

GoBucks wrote:
I'm trying to write a fomula that will look in column A for any text that
contains the text "LOA". If TRUE, I want to apply some conditional formatting
to a range of cells. I tried the following formula when A4 = "loa" and it
still comes up TRUE. Any suggestions?

=ISNUMBER(SEARCH(UPPER("LOA"),A4))


SEARCH is not case sensitive. FIND is:

=ISNUMBER(FIND("LOA",A4))

Hi GoBucks,

Because FIND is case sensitive, that is precisely why I have used:

=ISNUMBER(FIND("LOA",UPPER(A4),1))

It does not matter whether A4 contains loa or Loa of loA or lOa ...
upper of that will always make is "LOA", which is why you will be able
to find "LOA" in UPPER(A4). As long as loa exists in cell A4 in some
form the FIND("LOA",UPPER(A4),1) will always return a number.

Thank you both! worked great.

"Glenn" wrote:

GoBucks wrote:
I'm trying to write a fomula that will look in column A for any text that
contains the text "LOA". If TRUE, I want to apply some conditional formatting
to a range of cells. I tried the following formula when A4 = "loa" and it
still comes up TRUE. Any suggestions?

=ISNUMBER(SEARCH(UPPER("LOA"),A4))


SEARCH is not case sensitive. FIND is:

=ISNUMBER(FIND("LOA",A4))