conditional formatting

[Guest]

I am using this example: http://www.contextures.com/xlCondFormat03.html#List

the only difference is my "Codes" contain some text PLUS one of the
values... is there a way to modify this so that it checks all the text within
the cell...

this formatting works like a charm if only the value of the list is in the
cell being check, but i need it to truncate the data and just check to see if
the value exisits ANYWHERE in the cell...

any ideas?

 

[Peo Sjoblom]

Use this under formula is

=ISNUMBER(SEARCH("text_you_want_to_check",A1))

or

=COUNTIF(A1:A1,"*text_you_want_to_check*")>0

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)