Calculate Cell Values Based on Font, Background, or Conditional Color in Excel 365!!
Tags: calculatecellvaluesi, kutoolsexceltutorial, kutools
Published: 2020-11-17 10:55:53

---
title: Calculate Cell Values Based on Font, Background, or Conditional Color in Excel 365!!
published: true
date: 2020-11-17 09:26:40 UTC
tags: CalculateCellValuesi,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/calculate-cell-values-based-on-font-background-or-conditional-color-in-excel-365/
---

In this article, we are going to see how to **Calculate Cell Values Based on Font, Background, or Conditional Color in Excel Office 365** using **Kutools.** Let’s get into this article!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Apply Calculation to Cells Based on Cell Color:

If you want to apply the calculation to cells based on cell color in Excel, then follow the below steps.

- Let’s consider the below **example data** where you can see the range of cells with some background colors, and we are going to apply the calculations to them based on cell color.
- To do this, you need to **select the range** that you want to apply calculations based on their background-color.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example-37.png)<figcaption id="caption-attachment-17445">Example</figcaption>

- On the **Kutools Plus Tab, select** the **Count by Color** option.

![Select the Count by Color option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Count-by-Color-option.png)<figcaption id="caption-attachment-17446">Select the Count by Color option</figcaption>

- It will open the **Count by Color Dialog Box**.
- **Color method box –** From this drop-down list, you need to **select any one of the options**.
- **Count type box –** You need to **select** the **Background** option from the drop-down list.
- **Count –** This section will calculate how many cells are there with specific background colors in the range.
- **Sum –** It will add the numbers in the cells based on specific cell colors in the range.
- **Average –** This section will return the average of the cells with specific cell colors in the range.
- **Max –** It will display the maximum value of the cells with specific cell colors in the range.
- **Min –** With this section, you can see the minimum value of the cells with specific cell colors in the range.

![Count by Color Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-23.png)<figcaption id="caption-attachment-17447">Count by Color Dialog Box</figcaption>

 

### Note:

- There are **three options** in the **Color method** drop-down list, let’s see them below.
- **Standard formatting –** If you need to calculate cells by background colors that are formatted with the **Home> Fill Color** option, then you need to select this option.
- **Conditional formatting –** To calculate cells by background-color that are formatted by Conditional Formatting, please select this option.
- **Standard and Conditional formatting –** If you need to calculate all cells by background color, select this option.

- Finally, you need to **click** the **Generate report** button to view the report in the new workbook as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Output-9.png)<figcaption id="caption-attachment-17448">Output</figcaption>

## Count/Sum Calculations to Cells Based on Font Color:

To Count or Sum cells based on font color in the Excel spreadsheet, follow the below steps.

- For **example,** you can see the **range of cells formatted by various font colors** as shown in the below image. We are going to calculate those cells based on their font color.
- First, you need to **select the range** that you want to calculate cells by font colors.

![select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-22.png)<figcaption id="caption-attachment-17449">select the range</figcaption>

- Go to the **Kutools Plus Tab, select** the **Count by Color** option.

![Select the Count by Color option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Count-by-Color-option.png)<figcaption id="caption-attachment-17446">Select the Count by Color option</figcaption>

- It will open the **Count by Color Dialog Box**.
- **Color method box – ** You can **select any one of the options** as you need. Here, we **choose** the **Standard and Conditional formatting** option.
- **Count type box – ** You need to **select** the **Font** option from the drop-down list.

![Count by Color Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-22.png)<figcaption id="caption-attachment-17450">Count by Color Dialog Box</figcaption>

- Then, you need to **click** the **Generate report** option.
- At last, you will see the report in the new workbook as shown in the following image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Result-16.png)<figcaption id="caption-attachment-17451">Result</figcaption>

## Verdict:

In the above article, you can learn the steps to **Calculate Cell Values Based on Font, Background, or Conditional Color in Excel Office 365** using **Kutools.** Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [Encrypt & Decrypt Selected Cell Values/Contents In Excel 365!!](https://geekexcel.com/encrypt-decrypt-selected-cell-values-contents-in-excel-365/)
- [How to Insert a Monthly or a Yearly Calendar in Excel Office 365?](https://geekexcel.com/how-to-insert-a-monthly-or-a-yearly-calendar-in-excel-office-365/)