Hi,
Ratehr new at this.
Have made a macro with the a function to count cells with different fill colours. the thing I need is to disregard the cells with the given colour that have text fill. Is that possible? Macro and Function below.
MACRO;
Function Countcolour(rng As Range, colour As Range) As Long Dim c As Range Application.Volatile For Each c In rng If c.Interior.ColorIndex = colour.Interior.ColorIndex Then Countcolour = Countcolour + 1 End If Next End Function
FUNCTION;
=(Countcolour($A$1:$AL$88;$B$43))-1
Any input would be valuable.
Thanks!
Bookmarks