I want to do more than three conditional formats....the condition is if the
word 'deliver' exists the color should be green....if the word 'tank set'
exists the color should be off white....I have about twenty words with twenty
different colors...any suggestions. Thanks Chris