EXCEL: COUNTIF FUNCTION DEPENDING ON THE COLOUR OF THE CELL

Question

excel: I want to use the "countif" function in order to count the number of cells that have a specific colour (Doing this in order to count cells due to the containing number or text is clear and easy)

Answer 1

try this:

Open Excel, Alt+F11, On Modules add new Module and write this:

Function ColorCount(varRange As Range, varColor As Range) As Variant

Dim VarTemp As Variant, cell As Range

ColorCount = 0

For Each cell In varRange

If cell.Interior.ColorIndex = varColor.Interior.ColorIndex Then

ColorCount = ColorCount + 1

End If

Next

End Function

Use formula:

=Colorcount(Column;selected color cell)

Answer 2

While COUNTIF itself doesn’t directly count cells by color, you can use conditional formatting to highlight cells with a specific color.

May these articles help you:

https://www.howtoexcel.org/count-colored-cells/

https://www.exceldemy.com/excel-formula-to-count-cells-with-specific-color/

** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful **

Answer 3

Hi @Nikos kargopoulos

You may use GET.CELL and countif functions to count the number of cells of different colors.

For more, please refer to: https://trumpexcel.com/count-colored-cells-in-excel/#:~:text=Rows%20in%20Excel%3F-,%232%20Count%20Colored%20Cells%20Using%20GET.CELL%20Function,-GET.CELL%20is

• Create a Named Range using GET.CELL function
• Use the Named Range to get color code in a column
• Using the Color Number to Count the number of Colored Cells (by color)

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---