Conditional Formatting

[Wanna Learn]

Hello Whenever the letters BQ appears in a cell I want to format that cell
in yellow . This is what I did
format>conditional format>formula is =A1 ="BQ" then I selected the
formating. This does not work because there are 4 numbers before the letters
BQ > I tried several combinations, " BQ", "****BQ" How do I correct this?
thanks

 

[bj]

try
=right(a1,2)="BQ"

 

[Roger Govier]

Hi

If there are always 4 numbers before the BQ then
=MID(A1,5,2)="BQ"

 

[David Biddulph]

=RIGHT(A1,2)="BQ"
or (if you just want to look for BQ anywhere in the cell)
=ISNUMBER(SEARCH("BQ",A1))
or =ISNUMBER(FIND("BQ",A1)) if you want it case sensitive.

 

[bj]

another way
=not(iserrorfind("BQ",A1)<len(A1)))
this should work if BQ is anywhere in cell A!