# How to Change Cell Color Based on the Percentage in Excel

We can often find ourselves in a situation where we need to manipulate percentages in Excel. It is so much easier, as for dates, to just observe the percentages as for what they are- numbers.

In the text below, we will show how to change cell color based on percentages.

## Change Cell Color with Formula

For the example, we will use the table with sales numbers for company XY for the period from 2014 till 2020:

To see the percentage of each year in total sales, all we need to do is divide the number of sales for each year with total sales:

Our formula in cell C2 will be:

``=B2/\$B\$9``

And we will drag this formula until the ninth row. Our table now looks like this.

Now let us say that we want to highlight the numbers in column B that takes between 10 and 15 percent of total sales.

We need to use a formula for this. We will select column B, go to the Home tab >> Styles >> Conditional Formatting >> New Rule:

When we click on it, on the pop-up window that appears, we will choose the last option- Use a formula to define which cells to format.

Then we will input our formula:

``=AND(C1>10%,C1<=15%)``

Finally, we will define that these cells should be highlighted in green:

Now we will have our values in column B highlighted as defined:

## Change Cell Color with Other Conditional Formatting Rules

We can manipulate formatting styles and colors with other conditional formatting rules as well. To show this in a particular example, we will highlight all the cells in column C that are larger than 20 percent.

To do this, we need to select range C2:C8 (to exclude the total sales) and then go to Conditional Formatting >> Highlight Cells Rules >> Greater Than:

On a pop-up window that appears, we will input desired number (20 percent) and format these cells with yellow color:

Now, our table looks like this:

We could have also left this table intact, and create another IF formula in column D:

``=IF(C2<20%,"Bad year","Good year")``

As seen, every year in which less than 20 percent of total sales were achieved will be considered to be a bad year, while every other year will be a good year.

Results are as follows:

Now we can use this column to highlight the cells we want. We will highlight all the bad years by going to Conditional Formatting >> Highlight Cells Rules >> Text that Contains:

On a pop-up window that appears, we will input desired words: “Bad year”, and highlight them with red color:

Finally, our table looks like this: