Forum Discussion
Conditional formatting formulas
Is there a way to create a formula that would take a certain area and sum up the numbers of cells that are formated a certain way? Could i highlight cells different colors and have a formula that sum...
I support the approach Ingeborg suggested. However, you may do the calculations of cells content (sum, count, etc) based on their color using VBA (one of many examples is here https://support.microsoft.com/en-us/help/2815384/count-the-number-of-cells-with-specific-cell-color-by-using-vba) or using third-party tools like Kutools for Excel.
For many reasons I don't use VBA and third-party tools, thus can't share more practical details.