You can't.

Excel doesn't recalculate when a color changes.

You either have to force excel to recalc (F9) or wait until xl recalculates.

Cheryl L wrote:

I have a macro that counts the number of cells with a specific color and
totals the number in a separate cell. How can I get the totals to
automatically update when I change the color of a cell?

Thanks in advance!!

--

Dave Peterson