Excel VBA SUMIF by font color
Hello, we are going to walk you through via a customised user defined function, in order to sum a range based on a specific font colour.
We have some example invoice amounts from a law firm, which I want to reconcile to the source invoices. The user-defined function will sum cells in a selected range, based on a specified font colour of the cells i.e. red font.
This is a follow-up to an earlier video, Excel VBA SUMIF by fill color • Excel VBA SUMIF by fill color