I was able to count cells by their background color by the following:
Function CountColour(rng As Range, clr As Range)
Dim c As Range
For Each c In rng
If c.Interior.ColorIndex = clr.Interior.ColorIndex Then
CountColour = CountColour + 1
However, I need to add an IF function to this module… Any suggestions????
I am not very proficient in Excel and simply adding the module was a big win, but I’m not quite there yet… :/
PLEASE HELP ME!