color function formula
color function formulas that would allow you to enter a formula as normal and then count the number of colored cells in a range of cells. This would eliminate the need to format the data and then manually count the number of cells.
I think it would be great if there was a function returning the background color of a cell so the result could be used in other formulas (in a simple if or a countif)
But for now, if you want to count the number of non empty cells in a column with ONE background color, you can achieve this by using a table with a total row count [subtotal(103, column )] filtered by color.