Forum Discussion
Count or Sum of values on the basis of font color
Hi Team, How to make calculation such as Count or sum of values on the basis of font color ?
If the font color has been applied directly, it requires VBA code. See for example How to sum and count cells by color in Excel
If the font color is the result of conditional formatting, you can use SUMIFS/COUNTIFS with the same conditions as the conditional formatting rule.