conditional formatting

[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

 

[Carim]

Hi,

Use Formula Is:

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

HTH
Cheers
Carim

 

[Guest]

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

 

[RagDyeR]

Try this with "Formula Is":

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

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

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