Forum Discussion
Counting text of a specific colour & font
Afraid that's if only with VBA, not with formula. Formulas work with cell values, not with their attributes like colors.
Afraid that's if only with VBA, not with formula. Formulas work with cell values, not with their attributes like colors.
Thank you SergeiBaklan . I am not that proficient with Excel, unfortunately, but when I accessed the Help function on using COUNTIF it suggested that "Excel supports User-Defined Functions using VBA operations on cells based on background or font colour."
Is it possible you could guide or demonstrate this for me, please?
Many thanks.
That's not my expertise. Please check https://techcommunity.microsoft.com/t5/Excel/sum-by-color-when-colors-are-set-by-conditional-formatting/m-p/36495#M8243, perhaps people who is discussin that could help.