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.

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.

Use "formula is" and enter this formula
=RIGHT(A1,3)="vac"
where A1 is the upper left cell in your selection.

" 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.