Excel is not updating formulas belarusian dating service
This lets me enter the following in cell A61: =countccolor(A: A59; B61) However, if I change the color of a cell (i.e.a whole row) in the range, the totals in the cells using the =countccolor function don't update.I have to click them and press f2 (or just double click them) and then enter, before the count changes.
Whatever criteria you use in your head to choose whether a cell is colored or not can probably be used as a criteria in a countif(s) type of function. I reread the part about putting the code "on the right worksheet module" and after trying all permutations, found one that did the trick.
(I only discovered this after an hour of tinkering, figuring I had botched the formula!
) Are there any ways around this so that it updates upon dragging the formula?
Specifically, the code you suggested goes in the code list for the actual sheet and the code I posted goes in a module.
Not immediately logical to me, but I think I understand it now.