Showing posts with label Excel tips. Show all posts
Showing posts with label Excel tips. Show all posts

Monday, August 3, 2015

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.

how to conditional formatting 1 select cells 675403

2. Click “Conditional Formatting” on the Ribbon.

how to conditional formatting 2 click conditional formatting 675403

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



4. Click on “Text that Contains”

how to conditional formatting 4 text that contains 675403 

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

how to conditional formatting 5 select text 675403 


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

how to conditional formatting 6 select format 675403 

7. Click OK 


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