HOW TO USE "CONDITIONAL FORMATTING" IN EXCEL

Change background color based on cell value in Excel

When we deal with huge data in Excel, we may want to pick out some specific data and highlight them, such as change their background color. Supposing you have a range of data, and now you need to color the values between 80 and 100, as the following screenshot shows, how could you change background color based on cell value?

Microsoft Excel's Conditional Formatting command can change background color for specific cells based on their values with following steps:

1. Select the range that you will work with;

2. Click the Home > Conditional Formatting > New Rule….

3. In the New Formatting Rule dialog box, select and highlight the Format only cells that contains item in the Select a Rule Type: box.

4. In the Format Only Cells with section, specify the conditions that you need.

• In the first drop down box, select the Cell Value;
• In the second drop down box, select the between;
• In the third and fourth box, enter the filter conditions, such as 80, 100.

5. Click the Format button.

6. In the Format Cells dialog box, set the background color under Fill tab.

7. Click OK button to save the settings. Then the specific cells with value between 80 and 100 are filled with the new background color in the selection. See screenshot: