Try:

Formula is: =FIND("vac",A1)

Change A1 to your column

All occurences of "vac" will be highlighted e.g vacation.

HTH

" wrote:

Can I use conditional formatting to color a cell if the cell "contains"
certain text. I need excel to be able to read "vac" at the end of
someones name, and then color that cell for me.