conditional formatting

  • Thread starter Thread starter Jack Sons
  • Start date Start date
J

Jack Sons

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
 
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
 
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 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
 
Back
Top