I have a spreadsheet with text, dates and numbers. I want to change the
color of the cell if a specific word is present within the cell. For
example. Mr Smith's Retirement. Conditional formatting only works if the
only word in the cell is exactly retirement. I want the cell to turn green
if the word retirement is present. Need about 4-5 differnt colors for
specific words.

thanks