Forum Discussion
Help with excel formula relating to certain coloured text
I have a spreadsheet that I use for bills of how much and when they are due to be paid, I'm trying to find out if there is a formula that enables me to pick out a certain coloured text e.g. column A ...
Excel formulas can’t read text color. To organize by week, it’s best to use a helper column (e.g., “Week 1”, “Week 2”) and then use SUMIF or FILTER.
If you must use text color, you’ll need VBA. Example:
Function SumByFontColor(rng As Range, colorCell As Range) As Double For Each cell In rng If cell.Font.Color = colorCell.Font.Color Then SumByFontColor = SumByFontColor + cell.Value Next End Function
Then use in Excel like:
=SumByFontColor(A1:A100, C1)
(C1 has the font color you want to match.)