Aug 28 2023 10:48 AM
Hi Team,
How to make calculation such as Count or sum of values on the basis of font color ?
Aug 28 2023 11:33 AM
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.