Forum Discussion
Tullyk
Feb 20, 2019Copper Contributor
excel developer codes
Hi, i have recently learnt how to enter a code in to the developer to enable the auto sum of cells with the same background colour. i was wondering if there is a code out there like this that will al...
JKPieterse
Feb 20, 2019Silver Contributor
Hi Kelly,
Using formatting of cells to do calculations isn't a very good solution. It requires VBA programming which is not very easy to maintain unless you know what you are doing. It is better (and more efficient) to base your calculations on the content of the cells so you can use built-in functions like SUMIF, SUMIFS and their look-a-likes.
Using formatting of cells to do calculations isn't a very good solution. It requires VBA programming which is not very easy to maintain unless you know what you are doing. It is better (and more efficient) to base your calculations on the content of the cells so you can use built-in functions like SUMIF, SUMIFS and their look-a-likes.