Conditional Formatting

D

don.cook

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

Toppers

Try:

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

Change A1 to your column

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

HTH
 
S

Sloth

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