Spreadsheet: 77534d1277991411-macro-with-conditional-formatting-sampletemplate22
Sheet: Sheet1

 |  | LEGEND |  |  |  |  | LEGEND
 |  | GROUP # | COLOR | # PER GROUP |  |  | GROUP # | COLOR | % OF SALES
 |  | GROUP 1 |  | 1 |  |  | GROUP 1 |  | 1
 |  | GROUP 2 |  | 2 |  |  | GROUP 2 |  | 2
 |  | GROUP 3 |  | 3 |  |  | GROUP 3 |  | 3
 |  | GROUP 4 |  | 4 |  |  | GROUP 4 |  | 4 | TOTAL
 |  | GROUP 5 |  | 5 |  |  | GROUP 5 |  | 5 | 15
 |  | location |  |  |  |  |  |  |  | % of Total
 |  | 140 |  |  |  |  |  |  |  | 0.3237
 |  | 200 |  |  |  |  |  |  |  | 0.3047
 |  | 179 |  |  |  |  |  |  |  | 0.2719
 |  | 184 |  |  |  |  |  |  |  | 0.2719
 |  | 188 |  |  |  |  |  |  |  | 0.2719
 |  | 18 |  |  |  |  |  |  |  | 0.2562
 |  | 238 |  |  |  |  |  |  |  | 0.2553
 |  | 19 |  |  |  |  |  |  |  | 0.2538
 |  | 8 |  |  |  |  |  |  |  | 0.2396
 |  | 90 |  |  |  |  |  |  |  | 0.2362
 |  | 76 |  |  |  |  |  |  |  | 0.2337
 |  | 56 |  |  |  |  |  |  |  | 0.2337
 |  | 45 |  |  |  |  |  |  |  | 0.2337
 |  | 655 |  |  |  |  |  |  |  | 0.2337
 |  | 4 |  |  |  |  |  |  |  | 0.2337
 |  |  |  |  |  |  |  |  |  | 0.2337
 |  |  |  |  |  |  |  |  |  | 0.224
 |  |  |  |  |  |  |  |  |  | 0.2078
 |  |  |  |  |  |  |  |  |  | 0.2034
 |  |  |  |  |  |  |  |  |  | 0.1941
 |  |  |  |  |  |  |  |  |  | 0.1878
 |  |  |  |  |  |  |  |  |  | 0.179
 |  |  |  |  |  |  |  |  |  | 0.179
 |  |  |  |  |  |  |  |  |  | 0.1765
 |  |  |  |  |  |  |  |  |  | 0.176
 |  |  |  |  |  |  |  |  |  | 0.1746
 |  |  |  |  |  |  |  |  |  | 0.1746
 |  |  |  |  |  |  |  |  |  | 0.1721
 |  |  |  |  |  |  |  |  |  | 0.1716
 |  |  |  |  |  |  |  |  |  | 0.1716
 |  |  |  |  |  |  |  |  |  | 0.1716
 |  |  |  |  |  |  |  |  |  | 0.1687
 |  |  |  |  |  |  |  |  |  | 0.1643
 |  |  |  |  |  |  |  |  |  | 0.1628
 |  |  |  |  |  |  |  |  |  | 0.1614
 |  |  |  |  |  |  |  |  |  | 0.1609
 |  |  |  |  |  |  |  |  |  | 0.1506
 |  |  |  |  |  |  |  |  |  | 0.1506
 |  |  |  |  |  |  |  |  |  | 0.1506
 |  |  |  |  |  |  |  |  |  | 0.1501
 |  |  |  |  |  |  |  |  |  | 0.1501
 |  |  |  |  |  |  |  |  |  | 0.1501
 |  |  |  |  |  |  |  |  |  | 0.1501
 |  |  |  |  |  |  |  |  |  | 0.1496
 |  |  |  |  |  |  |  |  |  | 0.1467
 |  |  |  |  |  |  |  |  |  | 0.1457
 |  |  |  |  |  |  |  |  |  | 0.1452
 |  |  |  |  |  |  |  |  |  | 0.1447
 |  |  |  |  |  |  |  |  |  | 0.1442
 |  |  |  |  |  |  |  |  |  | 0.1437
 |  |  |  |  |  |  |  |  |  | 0.1428
 |  |  |  |  |  |  |  |  |  | 0.1413
 |  |  |  |  |  |  |  |  |  | 0.1408
 |  |  |  |  |  |  |  |  |  | 0.1389
 |  |  |  |  |  |  |  |  |  | 0.1384
 |  |  |  |  |  |  |  |  |  | 0.1369
 |  |  |  |  |  |  |  |  |  | 0.1364
 |  |  |  |  |  |  |  |  |  | 0.1364
 |  |  |  |  |  |  |  |  |  | 0.1359
 |  |  |  |  |  |  |  |  |  | 0.1345
 |  |  |  |  |  |  |  |  |  | 0.134
 |  |  |  |  |  |  |  |  |  | 0.1335
 |  |  |  |  |  |  |  |  |  | 0.133
 |  |  |  |  |  |  |  |  |  | 0.1325
 |  |  |  |  |  |  |  |  |  | 0.1315
 |  |  |  |  |  |  |  |  |  | 0.131
 |  |  |  |  |  |  |  |  |  | 0.1301
 |  |  |  |  |  |  |  |  |  | 0.1296
 |  |  |  |  |  |  |  |  |  | 0.1286
 |  |  |  |  |  |  |  |  |  | 0.1286
 |  |  |  |  |  |  |  |  |  | 0.1281
 |  |  |  |  |  |  |  |  |  | 0.1281
 |  |  |  |  |  |  |  |  |  | 0.1281
 |  |  |  |  |  |  |  |  |  | 0.1281
 |  |  |  |  |  |  |  |  |  | 0.1271
 |  |  |  |  |  |  |  |  |  | 0.1266
 |  |  |  |  |  |  |  |  |  | 0.1261
 |  |  |  |  |  |  |  |  |  | 0.1257
 |  |  |  |  |  |  |  |  |  | 0.1257
 |  |  |  |  |  |  |  |  |  | 0.1257
 |  |  |  |  |  |  |  |  |  | 0.1257
 |  |  |  |  |  |  |  |  |  | 0.1257
 |  |  |  |  |  |  |  |  |  | 0.1257
 |  |  |  |  |  |  |  |  |  | 0.1252
 |  |  |  |  |  |  |  |  |  | 0.1252
 |  |  |  |  |  |  |  |  |  | 0.1247
 |  |  |  |  |  |  |  |  |  | 0.1247
 |  |  |  |  |  |  |  |  |  | 0.1247
 |  |  |  |  |  |  |  |  |  | 0.1227
 |  |  |  |  |  |  |  |  |  | 0.1227
 |  |  |  |  |  |  |  |  |  | 0.1227