Count cells based on their background color

[tomc72]

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

[#2]

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

[#3]

@tomc72 

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

[#4]

@Abiola1 Brilliant... thank you very much!

[#5]

@Abiola1 Also brilliant! Thank you so much!

[#6 · Accepted solution]

@tomc72,

You're welcome. Would appreciate you mark as the Best Response!

Stay Safe