I don't know if this is possible but what i need to do is count in a row the
number of cells that are not empty [=SumProduct((C$7:C$193<"")) easy enough]
and that are a specifit color. not so easy. I made a function that tests for
the specific color, TestColor(give cell here) but I don't know how to pass it
the cell row sumproduct is currently on. here is what i have [
=SUMPRODUCT((C$7:C$193<"")*(TestColor()) ] So i need to put the cell in test
color like so TestColor(C7) but it needs to change for each row SUMPODUCT is
on. is this possible or do i have to do everything in VBA? any help is
appreciated.