How to count and sum "Condtional formatting" cells by color in Excel 2010?

[Deleted]

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/ )

My question is: Is there any functional code (or other aproach) which can count and sum all cells by "Conditional formatted" colors, on one sheet, and that the generated result is linked through common formulas? That can be updated/refreshed/code run during the work process as a complete overview of colors of a matrix (and not by picking every color every time as I mentioned).

Thanks in advance!

[#2]

@Jamil 

Thank you Jamil for the code. I have tried to use it in Excel 2019 because the code is not working for me... I tried to replicate the formula to another range even in your file and the code did not work..

Thanks for reply

Stanley

[#3]

Hi There,

How to count conditionally formatted red color cell?

I've tried many codes but still not working...

Range Cell : D40:D70

Sample Color : K40

Count Cell : L40

Thanks.