Colors
2 Topics
How to count and sum "Condtional formatting" cells by color in Excel 2010?
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!Solved280KViews1like181Comments
conditional formatting colos scale. duplicating format to independent rows
I have this need. I need to conditional format, with color scales, thousands of rows, independent rows. in the attach, you can see in the left what I need as a result, but applying the conditional formatting and applying the format painter to the thousands of rows, takes the aggregated values to define the color scales. I need to format paint each row individually to get the expected result. is there any way to do it without having each set of rows individually? and having 1000s of cond formatting rules? Thanks, GabrielSolved1.5KViews0likes2Comments