In fact, it’s an easy argument to make that aside from Pivot Tables, Conditional Formatting is Excel’s most useful feature. Conditional Formatting essentially allows you to set specific rules in an if/then sort of language. Using our spreadsheet below, we can create easy rules to color code bills that have yet to be paid. Or, we could apply Conditional Formatting to bills we’ve paid, while adding a second condition to color code everything in the “utilities” category.

Learn how to Remove Duplicate Entries in ExcelLearn how to create a Pivot Table based on Multiple Tables in Excel 2013Here’s how to Add a Drop-Down List in Excel

  1. Open a workbook in Excel. For the sake of this tutorial, I’m going to fill it with dummy data. You can do the same, or work from an existing workbook; just be sure to save it first.
  2. Select the data to be formatted. In this case, we’re going to choose everything in Column G, the “Paid?” category. 
  3. Choose Conditional Formatting from the ribbon.
  4. We’re going to color-code bills that we haven’t paid. To do that, add “NO” to the Format cells that are EQUAL TO box, and then select a color option from the dropdown menu. Or, you can create your own using Custom Format… 
  5.  Press OK.

Learn how to Remove Duplicate Entries in ExcelLearn how to create a Pivot Table based on Multiple Tables in Excel 2013See how to use Conditional Formatting in Excel to Color-Code Specific Cells