CountByFontColor function

COUNTBYFONTCOLOR() Description

Many people use colors to indicate cells. Working with cell colors can make it easier to understand the data in a workbook. Excel .

Unfortunately, Excel does not have built-in functions for using cell colors as conditions in formulas. Building formulas that only count or sum cells of certain colors can get really cumbersome. This often results in complex formulas that are prone to errors when making changes.

The COUNTBYFONTCOLOR() function counts the number of cells that have a specific font color.

Main Features COUNTBYFONTCOLOR Functions

Syntax:

=COUNTBYFONTCOLOR(RangeToCount; SampleCell)

Parameters:

• RangeToCount: A range with cells to count.
• SampleCell: A cell that contains a color sample.

Example Usage

The COUNTBYFONTCOLOR() function is easy to use. You just need to select the desired range of cells and specify the cell that contains the desired color, and Excel will automatically count the number of cells with the same text color:

=COUNTBYFONTCOLOR(RangeToCount; SampleCell)

We will have the following result:

This example uses the following values:

• RangeToCount: A1:D10 - Range with cells.
• SampleCell: F3 - The cell that contains the required font color (red).

Do you recognize any of these situations?

• Not sure if YLC has this feature, but it would be useful to be able to count colored cells in a range. Let's say I have 17 cells with red font color in the range B1:B500. I need a formula that counts those 5 cells with red text.
• Can I use color as a condition for COUNTIF? I have a column in which I need to count the number of cells with red text.
• I noticed that in recent versions Excel you can sort by cell color and font. What about the function Excel ? Can formulas also work with cell and font colors?
• How do I count or sum cells by their fill or background color? It seems that in Excel There is no formula that allows you to count or sum a range of cells based on a specified background color.

Calculation notes

Because Excel only lists the formula when the value in the (referenced) cell changes, not when the colors change, some worksheet formulas don't always trigger to update. In this case, you can use F9 or Ctrl+Alt+F9 to update the formulas in YLC Utilities.

Download extension

You can use the function COUNTBYFONTCOLOR() by installing the extension YLC Utilities .

After that, this function will be available in all files that are opened in Excel .