How to Add Conditional Formatting in Excel 2013

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

Email* (will not be published)
*Indicates required field
Submit Comments

All Product Types Accessories Cars Digital Camcorders Digital Cameras eReaders GPS Laptops MP3 & Video Players Projectors Smartphones Software Storage Tablets / MIDs VoIP Wi-Fi
All Subcategories
All Subcategories All-Purpose Budget Business Desktop Replacement Gaming Multimedia Netbook Nettop Rugged Student Tablet PCs Ultraportable
Acer Alienware Apple Archos ASUS Averatec BenQ CTL Corp. Dell Digital Storm eMachines Emtec Everex Fujitsu GammaTech Gateway General Dynamics Getac Gigabyte Hercules HP HTC iBuyPower Intel Lenovo MSI Nokia Nvidia OCZ OLPC OQO Origin Panasonic Sager Samsung Sony Sylvania Systemax TabletKiosk Toshiba Verizon Viewsonic Viliv VooDoo Workhorse PC ZT Systems
Minimum Rating
Any Rating 4.5 Stars 4.0 Stars 3.5 Stars 3.0 Stars
Screen Size
10 11 12 13 14 15 16 17 18 20 4 5 6 7 8 9
1024x576 1024x600 1024x768 1200X800 1280 x 720 1280x1024 1280x768 1280x800 1366x678 1366x768 1440x1050 1440x900 1600x768 1600x900 1680x1050 1680x945 1920x1080 1920x1200 800x400 800x480
Weight Range
10.1 - 12.0 pounds 12.1 - 14.0 pounds 14.1 - 16.0 pounds 2 lbs 2 pounds and under 2+ lbs 2.1 - 4.0 pounds 4.1 - 6.0 pounds 6.1 - 8.0 pounds 8.1 - 10.0 pounds Over 16 pounds Under 2 pounds
more options