question about conditional format

[Jack Sons]

Hi all,

How to do the conditional formatting if I want in A3200 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

 

[Dave O]

I got the expected results with
=NOT(ISERROR(SEARCH("JSO",C5,1)))

.... assuming the cell containing JSO is cell C5. (You'll need to
change the formula so it's appropriate to your application.)

 

[Biff]

Try this:

=ISNUMBER(SEARCH("JSO",A3))

Biff

 

[Pete_UK]

You could try this:

=COUNTIF(A3,"*JSO*")

as the formula in your conditional formatting condition. Apply this to
A3 then use the Format Painter to apply it to your other cells.

Hope this helps.

Pete

 

[Jack Sons]

Thanks a lot Gentlemen.

Jack.