How to apply conditional formatting based on text in a cell?

1. Select the range of cells you want to apply conditional formatting to.
2. On the Home tab, click Conditional Formatting > Manage Rules.
3. In the Conditional Formatting Rules Manager box, click New Rule.
4. In the New Formatting Rule box, click Format only cells that contain.
5. Under Format only cells with, select Specific Text in the drop-down box.
6. Select ending with in the next drop-down box.
7. In the last drop-down box, enter the example text es.
8. Click Format, and then click the Font tab.
9. In the Color box, select a color for the highlighted cells.
10. In the Font style box, select Bold.
11. Click OK until you've closed the dialog boxes.