Forum Discussion

Copper Contributor

Jun 12, 2020

Sum by font colour in Excel? (VBA help anyone?)

Hi All I have a raw data, dataset which I receive but cannot control the source and structure of. It uses font colour to categorise the type of data Can anyone assist with a macro to "su...

ExampleData.xlsx15 KB

excel

Macros and VBA

Abiola1

MVP

Jun 12, 2020

HelloLindsay-V

You can check the links below to guide you in summing by font color

Formua based:

https://www.exceltrick.com/how_to/sum-cells-based-on-background-color/?

https://www.wallstreetmojo.com/excel-sum-by-color/

VBA

https://www.ablebits.com/office-addins-blog/2013/12/12/count-sum-by-color-excel/comment-page-2/

Lindsay-V

Copper Contributor

Jun 16, 2020

Hi Again Abiola1

Just thought I would confirm, the ablebits VBA code did cover it. I didnt notice at first that the long code provided included a font colour option as well as fill colour.

Many thanks for your help, this is much appreciated.