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

"Wanna Learn" wrote:

Hello Whenever the letters BQ appears in a cell I want to format that cell
in yellow . This is what I did
formatconditional formatformula 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