This way is pretty fast if you are constantly changing the grouping banding values
C1=Lowest Band Value next band in D1, then E1, F1 & G1 the highest
<table style=”border-collapse: collapse; width: 240pt;” border=”0″ width=”320″ cellspacing=”0″ cellpadding=”0″>
<tbody>
<tr style=”height: 14.4pt;”>
<td class=”xl64″ style=”height: 14.4pt; width: 48pt; font-size: 8pt; color: windowtext; font-family: ‘Arial Narrow’; border: none; background: #63be7b;” align=”right” width=”64″ height=”19″>£1</td>
<td class=”xl64″ style=”width: 48pt; font-size: 8pt; color: windowtext; font-family: ‘Arial Narrow’; border: none; background: #82c77c;” align=”right” width=”64″>£1,000</td>
<td class=”xl64″ style=”width: 48pt; font-size: 8pt; color: windowtext; font-family: ‘Arial Narrow’; border: none; background: #ffeb84;” align=”right” width=”64″>£5,000</td>
<td class=”xl64″ style=”width: 48pt; font-size: 8pt; color: windowtext; font-family: ‘Arial Narrow’; border: none; background: #fed480;” align=”right” width=”64″>£50,000</td>
<td class=”xl64″ style=”width: 48pt; font-size: 8pt; color: windowtext; font-family: ‘Arial Narrow’; border: none; background: #f8696b;” align=”right” width=”64″>£250,000</td>
</tr>
</tbody>
</table>
Table of values column C3
and copy in
=IF(C3>C$1,IF(C3>D$1,IF(C3>E$1,IF(C3>E$1,IF(C3>F$1,IF(C3>G$1,”£”&TEXT(G$1,”#,##0″)&”+”,”£”&TEXT(F$1,”#,##0″)&”>£”&TEXT(G$1,”#,##0″)),”£”&TEXT(E$1,”#,##0″)&”>£”&TEXT(F$1,”#,##0″)),”£”&TEXT(D$1,”#,##0″)&”+”),”£”&TEXT(D$1,”#,##0″)&”>£”&TEXT(E$1,”#,##0″)),”£”&TEXT(C$1,”#,##0″)&”>£”&TEXT(D$1,”#,##0″)),”£000>£”&TEXT(C$1,”#,##0″))
This will produce its own labels against each value in column C