User Profile
Pau_Me
Copper Contributor
Joined 7 years ago
User Widgets
Recent Discussions
Re: How to count by FONT COLOR in excel when font color depends on a conditional formatting rule?
Subodh_Tiwari_sktneer hi dear! thanks for taking time to help. I am a little bit lost. Please enlighten me. (1) the first set of codes, this is VB code and will be placed in module 1, right? (2) the 2nd set of codes, where will I insert this? I tried putting both sets of codes in the VB-module. However, I cant figure out the formula that has to be entered in excel. I tried this... more functions > user defined category > getCountBasedOnCFFontColor the formula i used... =getCountBasedOnCFFontColor(B17:B1016,B17) B17:B1016 is the range the last B17 is the first cell of my data in RED FONT COLOR (i doubted this) thank you very much again! looking forward to hear an update!7.1KViews0likes3CommentsHow to count by FONT COLOR in excel when font color depends on a conditional formatting rule?
Hi! I came across to this thread coz i was looking for an answer to my problem. And found this post "sum by color when colors are set by conditional formatting" However, what I want is to count all cells with red font color in a range but the FONT COLOR was based on the conditional formatting. Example: range is A1:A1000 then the formatting I made was to turn DUPLICATE ENTRIES into a RED FONT COLOR. regardless of the text content. if apple and banana were duplicated twice. the result should give me NOT 2 BUT 4. Thanks in advance!7.4KViews0likes5CommentsRe: How to count and sum "Condtional formatting" cells by color in Excel 2010?
Jamil Hi! I came across to this thread coz i was looking for an answer to my problem. And found that you posted one for "sum by color when colors are set by conditional formatting" However, what I want is to count all cells with red font color in a range but the FONT COLOR was based on the conditional formatting. Example: range is A1:A1000 then the formatting I made was to turn DUPLICATE ENTRIES into a RED FONT COLOR. regardless of the text content. if apple and banana were duplicated twice. the result should give me NOT 2 BUT 4. Please help me. Thanks in advance!6KViews0likes3Comments
Recent Blog Articles
No content to show