Excel Online Color Counting

Copper Contributor

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
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.