| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting a range with conditional formatting | Excel Worksheet Functions | |||
| conditional formatting glitches | Excel Discussion (Misc queries) | |||
| Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
| conditional formatting | Excel Discussion (Misc queries) | |||
| cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
Hybrid Mode
