How to count cells by color in Excel Code - Custom functions to count by color in Excel. --------- Function CountCellsByColor(data_range As Range, cell_color As Range) As Long Dim indRefColor As Long Dim cellCurrent As Range Dim cntRes As Long Application.Volatile cntRes = 0 indRefColor = cell_color.Cells(1, 1).Interior.Color For Each cellCurrent In data_range If indRefColor = cellCurrent.Interior.Color Then cntRes = cntRes 1 End If Next cellCurrent CountCellsByColor = cntRes End Function Syntax

Count von Count 💜🧛🏻 Count cupcake sandwiches 💜Who is next? 🤔 👀 l used wiltoncakes piping tips 1M for the filling, 233 for the fur and 1A for his ears. I made his eyes nose and beard from fondant. His fangs are sprinkles. I coloured my buttercream and cupcake using colour mill purple oil colour 💜#cupcake #sesamestreet #countvoncount | Caked By Rach