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
|