Forum Discussion

jasonreid98's avatar
jasonreid98
Copper Contributor
Feb 18, 2022

Excel Online Color Counting

Good morning.  I have an Excel Online Workbook, with a series of columns, and the cells in each column are set to one of four colors.  I am trying to find a way to count the number of cells of each color in the column?  Any assistance would be appreciated!

1 Reply

  • JMB17's avatar
    JMB17
    Bronze Contributor
    The only two ways I know involve vba, or using an old xlm macro (get.cell - which can only be used as a named formula) and I don't believe either macros or name manager are available in online excel.

Resources