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)
I would be very grateful to know if this is possible - and how the formula might look, please.
Many thanks,
Tom
5 Replies
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
- Hello,
You can watch the short videos below to guide you
https://m.youtube.com/watch?v=8FyyXMC9Jdo&t=228s
https://m.youtube.com/watch?v=-9SHMwW5BhY
Cheers
