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...
Hello,
color and formatting is not data. If you manually set the color of cells because they belong to a certain category, then the logic for that is inside your head, not in the spreadsheet. A better approach would be to enter the category value into the spreadsheet and then use conditional formatting to set the color based on the category value.
With this approach you can then also very easily use formulas and/or pivot tables to summarize your data according to their category.