Forum Discussion

Lindsay-V's avatar
Lindsay-V
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...
excel
Macros and VBA
  • Lindsay-V's avatar
    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. 

  • Lindsay-V's avatar
    Lindsay-V
    Copper Contributor
    Jun 16, 2020

    Hi Abiola1 

    thanks for these links. Unfortunately the two excel solutions are both based on background colour (not Font Colour) and the =get.cell function is "not valid"   I guess i have to add it somehow, but unless one can "get font" colour then it doesnt help. 

     

    The VBA version is also based on background colour, but i am going to see if i can replace GetCellColor with getfontcolour

     

    wish me luck

    🙂

Resources