Forum Discussion
Solved
Count cells based on their background color
I would like to know if is it possible to count a range of cells where the result is based on the background colour of the cell i.e: Countif(A6:A23,where the cell background colour is the same as A6...
Tom, please check https://trumpexcel.com/count-colored-cells-in-excel/, here are all options.
If with VBA, step by step instruction is here https://docs.microsoft.com/en-us/previous-versions/office/troubleshoot/office-developer/count-cells-number-with-color-using-vba