SOLVED
Home

Counting text of a specific colour & font

%3CLINGO-SUB%20id%3D%22lingo-sub-486334%22%20slang%3D%22en-US%22%3ECounting%20text%20of%20a%20specific%20colour%20%26amp%3Bamp%3B%20font%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-486334%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20establish%20a%20COUNTIF%20formula%20that%20will%20accurately%20count%20the%20number%20of%20identical%20single%20text%20characters%20in%20a%20specific%20colour%20in%20a%20range%20of%20cells%20in%20a%20row%20that%20contains%20the%20same%20text%20character%20in%20a%20different%20colour.%20Is%20this%20possible%2C%20please%3F%20If%20so%20I%20would%20be%20very%20grateful%20for%20help%20with%20this%20request.%20Many%20thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-486334%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-486457%22%20slang%3D%22en-US%22%3ERe%3A%20Counting%20text%20of%20a%20specific%20colour%20%26amp%3Bamp%3B%20font%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-486457%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F324038%22%20target%3D%22_blank%22%3E%40topcat999%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAfraid%20that's%20if%20only%20with%20VBA%2C%20not%20with%20formula.%20Formulas%20work%20with%20cell%20values%2C%20not%20with%20their%20attributes%20like%20colors.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-486618%22%20slang%3D%22en-US%22%3ERe%3A%20Counting%20text%20of%20a%20specific%20colour%20%26amp%3Bamp%3B%20font%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-486618%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B.%20I%20am%20not%20that%20proficient%20with%20Excel%2C%20unfortunately%2C%20but%20when%20I%20accessed%20the%20Help%20function%20on%20using%20COUNTIF%20it%20suggested%20that%20%22Excel%20supports%20User-Defined%20Functions%20using%20VBA%20operations%20on%20cells%20based%20on%20background%20or%20font%20colour.%22%3C%2FP%3E%3CP%3EIs%20it%20possible%20you%20could%20guide%20or%20demonstrate%20this%20for%20me%2C%20please%3F%3C%2FP%3E%3CP%3EMany%20thanks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-487550%22%20slang%3D%22en-US%22%3ERe%3A%20Counting%20text%20of%20a%20specific%20colour%20%26amp%3Bamp%3B%20font%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-487550%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20that%2C%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E.%20Your%20help%20and%20advice%20greatly%20appreciated.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-487849%22%20slang%3D%22en-US%22%3ERe%3A%20Counting%20text%20of%20a%20specific%20colour%20%26amp%3Bamp%3B%20font%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-487849%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F324038%22%20target%3D%22_blank%22%3E%40topcat999%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20not%20my%20expertise.%20Please%20check%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fsum-by-color-when-colors-are-set-by-conditional-formatting%2Fm-p%2F36495%23M8243%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fsum-by-color-when-colors-are-set-by-conditional-formatting%2Fm-p%2F36495%23M8243%3C%2FA%3E%2C%20perhaps%20people%20who%20is%20discussin%20that%20could%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E
topcat999
Occasional Contributor

I am trying to establish a COUNTIF formula that will accurately count the number of identical single text characters in a specific colour in a range of cells in a row that contains the same text character in a different colour. Is this possible, please? If so I would be very grateful for help with this request. Many thanks.

4 Replies
Solution

@topcat999 ,

 

Afraid that's if only with VBA, not with formula. Formulas work with cell values, not with their attributes like colors.

Thank you @Sergei Baklan . I am not that proficient with Excel, unfortunately, but when I accessed the Help function on using COUNTIF it suggested that "Excel supports User-Defined Functions using VBA operations on cells based on background or font colour."

Is it possible you could guide or demonstrate this for me, please?

Many thanks.

 

Thank you for that, @Sergei Baklan. Your help and advice greatly appreciated. 

@topcat999 ,

 

That's not my expertise. Please check https://techcommunity.microsoft.com/t5/Excel/sum-by-color-when-colors-are-set-by-conditional-formatt..., perhaps people who is discussin that could help.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies