Problem with function vba not updating

[Alpacino]

I have a simple function sort of like countif but basically in a range counts if the cell interior is vbGreen then count. But it falls to update once the cell actually changes color. Any reason why this would happen??

 

[shg]

Changing the color of a cell doesn't cause the worksheet to recalculate, so it will never update automatically.

Color is not data to Excel.

 

[Cindy Ellis]

Reformatting doesn't trigger a recalculation, so if the only thing that changed was the cell color, it won't automatically recalculate. If the only change is to the format, you will need to press F9 to force the recalculation.
Hope that helps,
Cindy

 

[Alpacino]

Thanks everyone.