I am currently working on a project in which I will need to calculate the sum of each column, based off the conditional format color. I have tried everything to using the conditional formatting formulas as just a regular sum formula, as well as even looking up macros to use.
However, all the macros I found were for the whole set of data, calculating the sum of the whole data for each conditional color. However, I am looking to calculate each conditional color per column. Any help would be greatly appreciated