Count colored cells in excel 😱😱🔥#shorts #excel

In this video I will show you How to Count Color Cells in Excel using VBA

Thanks for watching! If you liked the video, make sure to give it a thumbs up and subscribe to our channel for more great content !

Instagram👇🏼

#youtubeshorts #unstoppableexceltips #trending

[bondsobond]

Function COUNTIFCOLOUR(Colour As Range, rng As Range) As Long
Dim NoCells As Long
Dim CellColour As Long
Dim rngCell As Range
CellColour = Colour.Interior.Color
For Each rngCell In rng
If rngCell.Interior.Color = CellColour Then
NoCells = NoCells + 1
End If
Next
COUNTIFCOLOUR = NoCells
End Function

[NonCrazyNorGamer]

It breaks once you exit the file even after saving

[bbbb]

How to add the values inside the color cells?