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

conditional formatting
 

Hi,

Use Formula Is:

=COUNTIF(A3,"*~JSO")=1

HTH
Cheers
Carim

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

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