Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"CONTAINS" operator?
Hi Marcelo,
I just assumed that the OP would want to take some action based upon the test, not that he just wanted True/False. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Marcelo" wrote in message ... hi Bob, just to clarify my mind and learn more with you. why did you use IF(isnumber....instead of isnumber? -- regards from Brazil Thanks in advance for your feedback. Marcelo "Bob Phillips" escreveu: =IF(ISNUMBER(FIND("ORDER",A1)),... -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dave Bilger" wrote in message ... I am using excel 2002. I want a cell to use conditional formating, whereby say IF CELL A1 CONTAINS "ORDER" THEN A2 WILL TURN A SPECIFIC COLOR. I can easily figure this out if A1 EQUALS "ORDER", but can't figure out the operator or trick for CONTAINS ... I've tried =A1="*ORDER*" but it doesn't work . . . Can anyone help me? -- Dave Bilger ------------------------------------------------------------------------ Dave Bilger's Profile: http://www.excelforum.com/member.php...o&userid=37600 View this thread: http://www.excelforum.com/showthread...hreadid=572336 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
"CONTAINS" operator? | Excel Worksheet Functions | |||
add one cell with no equals operator | Excel Discussion (Misc queries) | |||
corrupt program or file? How to tell? Or is it operator error? | Excel Discussion (Misc queries) | |||
"OR" operator to evaluate multiple conditions | Excel Worksheet Functions |