Take a look at http://www.xldynamic.com/source/xld.ColourCounter.html, that
is exactly what I do there.

--

HTH

Bob

"rk0909" wrote in message
...
I have this simple function to capture back ground color of a cell.

Function BGCol(refRange As Range)
BGCol = refRange.Interior.ColorIndex
End Function

I want to convert this to an array function where that array can store
colorindex for all the cells in a specified range and then i can use it in
a
sumproduct formula to fins cells with a certain color.

Any help or direction appreciated.

Best,

RK