Hello, I have a function that counts (or sums) all the cells in a range that
have the same color than the sample cell
CountIfColor (Range,SampleCell)
I use a For-Next loop, and I compare the color of every cell with the color
of the sample cell.

The problem comes when I change the color of one of the cells of the range:
the function doesn't recalculates. If I change the value goes ok, but if I
change the color not.

I can't use Worksheet_Change because the function is located in an .xla
sheet, and the users do not know how to work with Vb.

Can someone give me an idea (maybe a different focus) to help me?

Thanks in advance