Hello !
Is there any functional code (or other approach) 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/run code during the work process as a complete overview of the all matrix colors.
The sample file I'm dealing with is here http://ge.tt/9dwKutm2
I installed few add-ins for counting "Conditional formatted" cells but all are generating an instant (one-time) numeric result by activating that command - Kutools and Ablebits.
Also, I tried a code which gives an instant counting of single picked color without a total sum of all other colors -in my case 12 colors in a 52x24 matrix. ("How to use the code to count colored cells and sum their values" - https://www.ablebits.com/office-addi...y-color-excel/ )
Any help is appreciated. Thanks !
Is there any functional code (or other approach) 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/run code during the work process as a complete overview of the all matrix colors.
The sample file I'm dealing with is here http://ge.tt/9dwKutm2
I installed few add-ins for counting "Conditional formatted" cells but all are generating an instant (one-time) numeric result by activating that command - Kutools and Ablebits.
Also, I tried a code which gives an instant counting of single picked color without a total sum of all other colors -in my case 12 colors in a 52x24 matrix. ("How to use the code to count colored cells and sum their values" - https://www.ablebits.com/office-addi...y-color-excel/ )
Any help is appreciated. Thanks !