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

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 2

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.

---