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