Re: $$Excel-Macros$$ Color count in a row

If you were looking to find how many yellows, and how many reds there are, then I would modify NOORAIN's code a little like so Function COLORCOUNT(rngArrayCells As Range, rngColorCell As Range) Dim rngCell As Range, lngCells As Long For Each rngCell In rngArrayCells If rngCell.Int

Re: $$Excel-Macros$$ Color count in a row

http://www.excelvbamacros.com/2011/02/function-to-count-cells-on-basis-of.html http://www.excelvbamacros.com/2011/02/function-to-count-specific-fill-or.html http://www.excelvbamacros.com/2011/02/function-to-sum-specific-fill-or.html http://www.excelvbamacros.com/2011/02/function-to-sum-cells-on-b

Re: $$Excel-Macros$$ Color count in a row

[Revised] Dear Naresh, Please try it.. *Function Color_Count(mycell As Range) i = 0 For Each Rng In mycell If Rng.Interior.ColorIndex > 0 Then i = i + 1 End If Next Color_Count = i End Function* Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Color count in a row

Dear Naresh, please see attached sheet, i hope it will help to u.. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Wed, Oct 19, 2011 at 4:21 PM, nares