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.