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?