SOLVED

Count cells based on their background color

%3CLINGO-SUB%20id%3D%22lingo-sub-1491811%22%20slang%3D%22en-US%22%3ECount%20cells%20based%20on%20their%20background%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1491811%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20know%20if%20is%20it%20possible%20to%20count%20a%20range%20of%20cells%20where%20the%20result%20is%20based%20on%20the%20background%20colour%20of%20the%20cell%20i.e%3A%3C%2FP%3E%3CP%3ECountif(A6%3AA23%2Cwhere%20the%20cell%20background%20colour%20is%20the%20same%20as%20A6)%3C%2FP%3E%3CP%3EI%20would%20be%20very%20grateful%20to%20know%20if%20this%20is%20possible%20-%20and%20how%20the%20formula%20might%20look%2C%20please.%3C%2FP%3E%3CP%3EMany%20thanks%2C%3C%2FP%3E%3CP%3ETom%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1491811%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1491832%22%20slang%3D%22en-US%22%3ERe%3A%20Count%20cells%20based%20on%20their%20background%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1491832%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20watch%20the%20short%20videos%20below%20to%20guide%20you%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fm.youtube.com%2Fwatch%3Fv%3D8FyyXMC9Jdo%26amp%3Bt%3D228s%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fm.youtube.com%2Fwatch%3Fv%3D8FyyXMC9Jdo%26amp%3Bt%3D228s%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fm.youtube.com%2Fwatch%3Fv%3D-9SHMwW5BhY%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fm.youtube.com%2Fwatch%3Fv%3D-9SHMwW5BhY%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3ECheers%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1491837%22%20slang%3D%22en-US%22%3ERe%3A%20Count%20cells%20based%20on%20their%20background%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1491837%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F388625%22%20target%3D%22_blank%22%3E%40tomc72%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETom%2C%20please%20check%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftrumpexcel.com%2Fcount-colored-cells-in-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftrumpexcel.com%2Fcount-colored-cells-in-excel%2F%3C%2FA%3E%2C%20here%20are%20all%20options.%3C%2FP%3E%0A%3CP%3EIf%20with%20VBA%2C%20step%20by%20step%20instruction%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fprevious-versions%2Foffice%2Ftroubleshoot%2Foffice-developer%2Fcount-cells-number-with-color-using-vba%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fprevious-versions%2Foffice%2Ftroubleshoot%2Foffice-developer%2Fcount-cells-number-with-color-using-vba%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1491936%22%20slang%3D%22en-US%22%3ERe%3A%20Count%20cells%20based%20on%20their%20background%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1491936%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3BBrilliant...%20thank%20you%20very%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1491938%22%20slang%3D%22en-US%22%3ERe%3A%20Count%20cells%20based%20on%20their%20background%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1491938%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3BAlso%20brilliant!%20Thank%20you%20so%20much!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1492482%22%20slang%3D%22en-US%22%3ERe%3A%20Count%20cells%20based%20on%20their%20background%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1492482%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F388625%22%20target%3D%22_blank%22%3E%40tomc72%3C%2FA%3E%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYou're%20welcome.%20Would%20appreciate%20you%20mark%20as%20the%20Best%20Response!%3CBR%20%2F%3E%3CBR%20%2F%3EStay%20Safe%3C%2FLINGO-BODY%3E
Contributor

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

@Abiola1 Brilliant... thank you very much!

@Abiola1 Also brilliant! Thank you so much!

 

Best Response confirmed by tomc72 (Contributor)
Solution
@tomc72,

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

Stay Safe