Oct 12 2017 02:29 PM
Oct 12 2017 02:29 PM
I installed few add-ins for counting "Conditional formatted" cells but all are generating an instant (one-time) numeric result by activating that command.
Also, I tried a code which gives an instant counting of 1 picked color without a total sum of all other colors -in my case 12 colors in a matrix. ("How to use the code to count colored cells and sum their values" - https://www.ablebits.com/office-addins-blog/2013/12/12/count-sum-by-color-excel/ )
Sep 02 2018 06:25 AM
Bad luck!
Is there any solution for my problem?
Sep 02 2018 10:43 AM
Sep 02 2018 09:47 PM
How can i open a new question?
Sep 03 2018 06:19 AM
Sep 05 2018 06:06 AM
Thank you very much.
Sep 29 2018 09:45 PM
Hello.. can you solve the problem for attached file?
I want to count the specific text colored by conditional formatting column wise. Conditional formatting done by formula.
Oct 08 2018 11:59 AM
Oct 14 2018 07:33 PM
you have a new question, so the experts would likely to answer your question over there.
Oct 22 2018 03:38 AM
Hi Jamil,
I had a similar issue to Julie.
I did exactly what you said and the document worked.
Since saving, closing the document and today opening it the formula doesn't seem to work when calculating the colored cells.
I get the '#NAME' error.
Any assistance you can offer would be appreciated...?
Document attached.
Oct 22 2018 03:52 AM
Oct 22 2018 03:07 PM
I have tried your formulas and they do not work. I have been stuck on this for 3 weeks now and I'm trying to count my cells as they turn certain colors from Conditional Formatting rules I put in place for my drop down menu's. If you would be able to assist me that would be wonderful because I am getting tired of watching and reading videos on how it wont work for me formulas.
Matthew
Oct 23 2018 08:18 AM
Oct 23 2018 09:41 AM
These are all the acronyms I am trying to achieve on my spreadsheet, thank you for your assistance
Matthew
Oct 27 2018 03:25 PM
Dec 13 2018 05:51 PM
Hi Jamil
I stumbled upon your code as I am using conditional formatting formula to highlights my cell. Now I want to count the highlighted cells.
Similar to Julie, the VBA returns "no color" instead of the numbers. I have done everything that I can possibly can.
I suspect it doesn't work because I use this formula in my conditional formatting =if(isblank($K$1),0,(search($K$1,A5))). A5 is where my data starts. K1 is where when someone type a text and that text is in the data, it will highlight those texts. Attached is an example (which didn't quite work but you'll get the idea).
Thanks for your help.
Dec 19 2018 08:24 AM
hi 7 Heven,
You have used Search function and also whole column reference A:A which is not compatible with the UDF. I have modified the formula and range in the attached example and the UDF works.
Dec 20 2018 05:51 PM
Hi Jamil
I can't believe my luck that you actually replied to my query! Thank you very much!
If I modified the formula as per your suggestion and remove the search function, it doesn't work on my master spreadsheet. Is there a way to modify the UDF to make it work with search function?
Many thanks again.
Jan 03 2019 05:39 PM
Hi Jamil I was able to successfully use your code to count my conditionally formatted cells but my data changes regularly and the function doesn't automatically refresh. In order for it to pick up the changes i have to refresh the cell with F2 and then enter, any solution for that?
Jan 04 2019 10:13 AM