Countif by Cell Background Color

COUNTIF by cells background color in Excel

COUNTIF is an extremely useful function in Microsoft Excel. We use this function to get the count based on some conditions. Here in this article, we have created a user-defined function to count based on the cell background color.


Learn useful formulas in Excel


Please watch the below video to learn the various methods of using the COUNTIF function in excel.

  1. Countifs for multiple conditions.
  2. Countif for counting the Character lengthwise.
  3. Countif by the partial value of the criteria range.
  4. Countif by cells background color (VBA method).
  5. Countif by cells bold font type (VBA method).
Countif by Cell Background Color
COUNTIF by Cell Background Color

Watch the step-by-step video tutorial:



Click here to download the practice file

My Name is PK. I am founder of I am a Microsoft Certified Professional. I have more than 12 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.