Conditional Formatting
 

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

Conditional Formatting
 

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

"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

Conditional Formatting
 

Hi

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

--
Regards

Roger Govier


"Wanna Learn" wrote in message
...
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

Conditional Formatting
 

=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.
--
David Biddulph

"Wanna Learn" wrote in message
...
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

Conditional Formatting
 

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