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