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