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