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.
2. Click "Conditional Formatting" on the Ribbon.
3. Hover over "Highlight Cells Rules" in the drop-down menu.
4. Click on "Text that Contains" in the drop-down menu.
5. Select the text you want formatted in the "Text that Contains" popup window.
6. Choose the format in the "Text that Contains" popup window.
Stay in the know with Laptop Mag
Get our in-depth reviews, helpful tips, great deals, and the biggest news stories delivered to your inbox.