How to add Conditional Formatting to an Excel Spreadsheet

Conditional formatting will apply colors to a cell’s font and background depending on the conditions you’ve set — if you want to highlight any cell that features a specific name or date, for instance, or differentiate high, medium and low numerical values. Follow these directions to set up your own conditional formatting in a few simple steps

1. Select the cells you want to format.



2. Click “Conditional Formatting” on the Ribbon.



3. Hover over “Highlight Cells Rules” in the drop down menu.



4. Click on “Text that Contains”

 

5. Select the text you want formatted in the “Text that Contains” pop up window.

 


6. Choose the format in the “Text that Contains” popup window

 

7. Click OK 


source: http://blog.laptopmag.com/excel-2013-conditional-formatting