How to Add Conditional Formatting in Excel 2013

  • MORE

how to conditional formatting lead 675403

Microsoft Excel 2013 introduces a new feature that lets you differentiate data at a glance: Conditional formatting. This handy tool 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.

how to conditional formatting 3 click highlight 675403

4. Click on "Text that Contains" in the drop-down menu.

how to conditional formatting 4 text that contains 675403

5. Select the text you want formatted in the "Text that Contains" popup 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

Recommended by Outbrain
Add a comment