Hi all,
thanks for your help in advance, I've been struggling to find something that fits my need. I have a table of KPI measurements for a number of people/ locations within tables that are conditionally formatted based upon the criteria.
I want to be able to count how many people/locations have met the kpi based on counting the color. Some of the conditional formatted measurements are values, some are text, some are blank, some are percentage measures - hence my asking for color.
I have 6 tables on 6 tabs, ranging in size. The countcellsbycolor macros that are about haven't worked because of the conditional formatting, but the principle of it is what I would like.
Summary of data below - each column has variety of colours:
<tbody>
</tbody>
thanks for your help in advance, I've been struggling to find something that fits my need. I have a table of KPI measurements for a number of people/ locations within tables that are conditionally formatted based upon the criteria.
I want to be able to count how many people/locations have met the kpi based on counting the color. Some of the conditional formatted measurements are values, some are text, some are blank, some are percentage measures - hence my asking for color.
I have 6 tables on 6 tabs, ranging in size. The countcellsbycolor macros that are about haven't worked because of the conditional formatting, but the principle of it is what I would like.
Summary of data below - each column has variety of colours:
95% | 95% | 2 | n | n/a | n/a | n/a | 5/5 | 5/5 | 47 | 215% | 1,468 | 1.90% | 0.87% | £10 | -£ 5,606 | 319 | £ 2,093 | -£ 153 | -£ 1,304 | £ 276 | |||||
55% | 55% | -9 | y | n/a | n/a | 2 (0) | 5/5 | 5/5 | 39 | 160% | 2,539 | 8.00% | 7.48% | £50 | -£ 15,548 | 27 | £ - | -£ 352 | £ 5,661 | -£ 925 | |||||
72% | 72% | -15 | n | 100% | 100% | 2 (0) | 5/5 | 5/5 | -17 | -62% | 2.10% | 3.85% | £93,122 | -£ 5,023 | 36 | £ - | £ 408 | £ 811 | £ 71 | ||||||
91% | 91% | -13 | y | 0% | 100% | 1 (1) | 1/5 4/5 | 1/5 4/5 | 87 | 414% | 1,557 | 17.40% | 2.99% | £22,861 | -£ 869 | -220 | £ 40 | -£ 43 | £ 82 | £ - | |||||
68% | 68% | -6 | n | 100% | 100% | 1 (1) | 5/5 | 5/5 | -11 | -18% | 1,199 | 0.00% | 3.12% | £85,033 | -£ 15,555 | 349 | £ 333 | -£ 657 | -£ 12,648 | £ 519 | |||||
75% | 75% | -3 | n | n/a | n/a | 2 (0) | n/a | n/a | n/a | 56 | 105% | 0.00% | -0.66% | -£11,554 | £ 8,104 | -82 | £ - | £ 120 | -£ 5,603 | £ 852 | |||||
86% | 86% | -29 | y | 33% | 67% | 2 (1) | 2/5 3/5 | 2/5 3/5 | 38 | 60% | 18,009 | 3.50% | 0.54% | £16,569 | -£ 8,013 | -138 | £ 81 | -£ 1,030 | -£ 202 | £ 174 | |||||
80% | 80% | -15 | y | n/a | n/a | n/a | 5/5 | 5/5 | -24 | -349% | 99 | 2.30% | 4.46% | £135,333 | -£ 6,728 | -158 | £ 65 | £ 551 | -£ 3,829 | -£ 513 | |||||
94% | 94% | -3 | n | 0% | 67% | n/a | 4/5 | E | 4/5 | -8 | -23% | 2,176 | 2.20% | 5.69% | £123,844 | -£ 10,972 | -57 | -£ 5,650 | -£ 1,121 | -£ 6,949 | -£ 386 | ||||
71% | 71% | -13 | y | n/a | n/a | n/a | 5/5 | 5/5 | 100 | 1129% | 2.50% | 10.94% | £77,355 | -£ 5,967 | 27 | £ 250 | -£ 229 | £ 344 | £ - | ||||||
20% | 20% | -42 | y | n/a | n/a | n/a | 5/5 | 5/5 | 160 | 187% | 5,604 | 0.00% | 5.65% | £160,430 | -£ 1,189 | -81 | -£ 45 | -£ 892 | £ 39 | £ 140 | |||||
80% | 80% | -17 | n | 50% | 50% | 1 (0) | 5/5 | 5/5 | -8 | -183% | 315 | 5.00% | 4.46% | £28,354 | -£ 1,906 | -282 | -£ 38 | -£ 215 | -£ 2,139 | £ - | |||||
90% | |||||||||||||||||||||||||
20% | |||||||||||||||||||||||||
50% | 50% | 8% | 50% | 33% | 50% | 100% | 100% | 91% | 90% | 100% | 100% | 58% | 25% | 25% | 25% | 50% | 42% | 8% | 42% | 75% | 25% | 42% | 75% |
<tbody>
</tbody>