|
"CONTAINS" operator?
Marcelo, Thank you (and all the rest of you). This hint does actually work great =isnumber(find("order",a2,1)) (This was the only one which works of all the suggestions) Is there a way to make it not case sensitive? Thanks ! Colorado Dave :) =============== Marcelo Wrote: Hi Dave, on conditional format change to the formula is and use =isnumber(find("order",a2,1)) format as you need hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Dave Bilger" escreveu: 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 -- 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 |
"CONTAINS" operator?
Use SEARCH instead of FIND.
Pete Dave Bilger wrote: Marcelo, Thank you (and all the rest of you). This hint does actually work great =isnumber(find("order",a2,1)) (This was the only one which works of all the suggestions) Is there a way to make it not case sensitive? Thanks ! Colorado Dave :) =============== Marcelo Wrote: Hi Dave, on conditional format change to the formula is and use =isnumber(find("order",a2,1)) format as you need hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Dave Bilger" escreveu: 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 -- 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 |
"CONTAINS" operator?
Hey, Pete_UK, the SEARCH part works ! Thanks a million to you and the rest !!! Genius Group . . . Colorado Dave :) -- 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 |
"CONTAINS" operator?
You're welcome.
Pete Dave Bilger wrote: Hey, Pete_UK, the SEARCH part works ! Thanks a million to you and the rest !!! Genius Group . . . Colorado Dave :) -- 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 |
| All times are GMT +1. The time now is 04:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com