| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
Hi all,
How to do the conditional formatting if I want in A3:P200 the back ground color of a cell to be yellow if it contains JSO. Example, cells may look like ABC/DEF/JSO/HIJ in which case I want the back ground yellow. I tried a lot, but =$A$3="*JSO*" or =$A$3="*"$"JSO"&"*" etc. won't work. I use Excel 2k. TIA Jack Sons The Netherlands |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting
Hi,
Use Formula Is: =COUNTIF(A3,"*~JSO")=1 HTH Cheers Carim |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting
Click on Format|Conditional Formating, set Cell Value is to Equal to, and in
the right hand text box type JSO. Now use your painter to format the rest of the range "Jack Sons" wrote: Hi all, How to do the conditional formatting if I want in A3:P200 the back ground color of a cell to be yellow if it contains JSO. Example, cells may look like ABC/DEF/JSO/HIJ in which case I want the back ground yellow. I tried a lot, but =$A$3="*JSO*" or =$A$3="*"$"JSO"&"*" etc. won't work. I use Excel 2k. TIA Jack Sons The Netherlands |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting
Try this with "Formula Is":
=ISNUMBER(SEARCH("JSO",A3)) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Jack Sons" wrote in message ... Hi all, How to do the conditional formatting if I want in A3:P200 the back ground color of a cell to be yellow if it contains JSO. Example, cells may look like ABC/DEF/JSO/HIJ in which case I want the back ground yellow. I tried a lot, but =$A$3="*JSO*" or =$A$3="*"$"JSO"&"*" etc. won't work. I use Excel 2k. TIA Jack Sons The Netherlands |
| 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 | |||
Linear Mode
