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...
Hi Eric,
If the cells are organized in a column way, can you consider to add a new column and set numerical values rather than colors then just use SUMIF() for each category.
Yeah, actually that might help. Thanks!