Spreadsheet: 181161d1347950109-conditional-formatting-advanced-example-20-1-1-
Sheet: 1615 Cost Transaction Drilldown

P/O Number | G/L Date | Hours / Litres | Amount | P/O Number | Amount
85076759 | 2012-09-02 00:00:00 | -0.5 | -37.96 | 85076759
85074642 | 2012-08-30 00:00:00 | -1 | -72.5 | 85074642
85074646 | 2012-08-31 00:00:00 | -4.5 | -427.5 | 85074646
85074655 | 2012-08-30 00:00:00 | -6 | -351 | 85074655
85074658 | 2012-08-30 00:00:00 | -3 | -188.85 | 85074658
85074662 |  | -24.5 | -1433.25 | 85074662
85074663 | 2012-08-30 00:00:00 | -5 | -314.75 | 85074663
85074664 | 2012-08-30 00:00:00 | -6 | -377.7 | 85074664
85074666 | 2012-08-30 00:00:00 | -4 | -251.8 | 85074666
85074667 | 2012-08-30 00:00:00 | -4 | -251.8 | 85074667
85075950 | 2012-08-30 00:00:00 | -2 | -151.84 | 85075950
85076744 |  | -32 | -2014.4 | 85076744
85076745 |  | -45.5 | -2864.23 | 85076745
85076746 |  | -27 | -1699.66 | 85076746
85076747 |  | -38.5 | -2252.25 | 85076747
85076748 |  | -36 | -2106 | 85076748
85076749 |  | -14 | -1120 | 85076749
85076750 |  | -36.5 | -2297.69 | 85076750
85076751 |  | -41.5 | -2612.45 | 85076751
85076752 |  | -28 | -2128 | 85076752
85076753 |  | -40.5 | -2369.25 | 85076753
85076755 | 2012-09-06 00:00:00 | -2 | -145 | 85076755
85076756 |  | -17 | -1290.64 | 85076756
85076759 |  | -8.5 | -645.32 | 85076776
85076776 |  | -17 | -1615 | 85076778
85076778 |  | -31 | -2945 | 85074651
85074642 | 2012-08-31 00:00:00 | -3 | -217.5 | 85075951
85074646 |  | -16.5 | -1567.5 | 85074643
85074651 | 2012-08-30 00:00:00 | -14.5 | -1377.5 | 85074661
85074662 | 2012-09-11 00:00:00 | -1 | -58.5 | 85076754
85075950 | 2012-08-30 00:00:00 | -6 | -455.52 | 85075952
85075951 | 2012-08-30 00:00:00 | -10.5 | -797.16 | 85072951
85076744 | 2012-09-11 00:00:00 | -1 | -62.95
85076746 | 2012-09-11 00:00:00 | -1 | -62.95
85076747 | 2012-09-11 00:00:00 | -1 | -58.5
85076753 | 2012-09-11 00:00:00 | -1 | -58.5
85076755 |  | -3.5 | -253.75
85076756 | 2012-09-11 00:00:00 | -2 | -151.84
85076759 |  | -5 | -379.6
85076776 |  | -7 | -665
85076778 |  | -6.5 | -617.5
85076755 | 2012-09-11 00:00:00 | -4 | -290
85076778 |  | -1 | -95
85076755 | 2012-09-04 00:00:00 | -5 | -362.5
85074642 | 2012-08-31 00:00:00 | -5 | -362.5
85076752 |  | -5.5 | -418
85076755 |  | -25 | -1812.5
85076756 | 2012-09-11 00:00:00 | -2 | -151.84
85076759 |  | -6 | -455.52
85076755 |  | -8 | -580
85076755 | 2012-09-07 00:00:00 | -9 | -652.5
85074642 |  | -7 | -507.5
85076755 |  | -5 | -362.5
85076756 |  | -5 | -379.6
85076759 |  | -4 | -303.68
85076776 |  | -9 | -855
85076778 | 2012-09-09 00:00:00 | -1 | -95
85074642 | 2012-08-30 00:00:00 | -2 | -145
85074643 | 2012-08-30 00:00:00 | -3 | -217.5
85074661 | 2012-08-30 00:00:00 | -5 | -400
85076749 |  | -7.5 | -600
85076754 |  | -12 | -870
85074643 |  | -10 | -507.5
85074661 | 2012-08-30 00:00:00 | -7 | -560
85076749 |  | -78 | -6240
85076754 |  | -57 | -4132.5
85074643 |  | -12 | -217.5
85076749 | 2012-09-10 00:00:00 | -4 | -320
85076754 | 2012-09-01 00:00:00 | -3 | -217.5
85076778 | 2012-09-10 00:00:00 | -0.5 | -47.5
85076755 | 2012-09-11 00:00:00 | -4 | -290
85076778 | 2012-09-10 00:00:00 | -0.5 | -47.5
85074642 | 2012-08-30 00:00:00 | -1 | -72.5
85075950 | 2012-08-31 00:00:00 | -12 | -911.04
85075951 |  | -15 | -1138.8
85076752 |  | -19.5 | -1482
85076755 | 2012-09-03 00:00:00 | -4 | -290
85076756 |  | -27 | -2049.84
85076759 |  | -30 | -2277.6
85076776 | 2012-09-11 00:00:00 | -9 | -855
85076778 | 2012-09-11 00:00:00 | -4 | -380
85076752 | 2012-09-10 00:00:00 | -4 | -304
85076755 |  | -5 | -362.5
85076752 | 2012-09-08 00:00:00 | -0.5 | -38
85076755 |  | -12 | -870
85074642 | 2012-08-30 00:00:00 | -3 | -217.5
85076752 |  | -4.5 | -342
85076776 |  | -6.5 | -617.5
85076759 | 2012-09-05 00:00:00 | -3 | -227.76
85076776 | 2012-09-05 00:00:00 | -3 | -285
85076752 | 2012-09-09 00:00:00 | -0.5 | -38
85076759 | 2012-09-02 00:00:00 | -0.5 | -37.96
85076752 | 2012-09-09 00:00:00 | -1 | -76
85076759 | 2012-09-02 00:00:00 | -0.5 | -37.96
85076755 | 2012-09-02 00:00:00 | -2 | -145
85076756 | 2012-09-04 00:00:00 | -2 | -151.84
85076759 | 2012-09-04 00:00:00 | -4 | -303.68
85076755 | 2012-09-03 00:00:00 | -1 | -72.5
85076778 | 2012-09-08 00:00:00 | -2.5 | -237.5
85076755 | 2012-09-03 00:00:00 | -1 | -72.5
85076755 | 2012-09-03 00:00:00 | -1 | -72.5
85076755 | 2012-09-03 00:00:00 | -1 | -72.5
85076776 | 2012-09-01 00:00:00 | -1 | -95
85076776 | 2012-09-01 00:00:00 | -1 | -95
85075952 | 2012-08-30 00:00:00 | -10.5 | -798
85074642 | 2012-08-30 00:00:00 | -1 | -72.5
85076778 | 2012-09-09 00:00:00 | -1 | -95
85076778 | 2012-09-07 00:00:00 | -0.75 | -71.25
85076778 | 2012-09-07 00:00:00 | -0.75 | -71.25
85076776 | 2012-09-04 00:00:00 | -0.5 | -47.5
85076778 | 2012-09-11 00:00:00 | -1 | -95
85076755 |  | -2 | -145
85076749 |  | -10 | -800
85076752 | 2012-09-06 00:00:00 | -14 | -1064
85076778 |  | -15.5 | -1472.5
85076778 | 2012-09-09 00:00:00 | -0.5 | -47.5
85074642 | 2012-08-30 00:00:00 | -1 | -72.5
85076755 |  | -7 | -507.5
85076759 | 2012-09-02 00:00:00 | -2 | -151.84
85076778 | 2012-09-09 00:00:00 | -2 | -190
85076748 | 2012-09-04 00:00:00 | -1 | -58.5
85076755 | 2012-09-03 00:00:00 | -1 | -72.5
85076756 | 2012-09-01 00:00:00 | -1 | -75.92
85076759 | 2012-09-01 00:00:00 | -0.5 | -37.96
85076756 | 2012-09-01 00:00:00 | -1 | -75.92
85076759 | 2012-09-01 00:00:00 | -0.5 | -37.96
85076756 | 2012-09-01 00:00:00 | -1 | -75.92
85076759 | 2012-09-01 00:00:00 | -0.5 | -37.96
85076778 | 2012-09-08 00:00:00 | -0.5 | -47.5
85076756 | 2012-09-01 00:00:00 | -1 | -75.92
85076759 | 2012-09-01 00:00:00 | -0.5 | -37.96
85076778 | 2012-09-08 00:00:00 | -0.5 | -47.5
85076756 | 2012-09-05 00:00:00 | -4 | -303.68
85076778 | 2012-09-10 00:00:00 | -2 | -190
85074646 | 2012-08-31 00:00:00 | -2 | -190
85076752 | 2012-09-09 00:00:00 | -1 | -76
85076759 | 2012-09-02 00:00:00 | -1 | -75.92
85076776 |  | -4 | -380
85076778 |  | -3 | -285
85076752 | 2012-09-09 00:00:00 | -2 | -152
85076778 | 2012-09-07 00:00:00 | -2.5 | -237.5
85074646 | 2012-08-31 00:00:00 | -5.5 | -522.5
85075950 | 2012-08-30 00:00:00 | -4 | -303.68
85076750 | 2012-09-06 00:00:00 | -4 | -251.8
85076751 | 2012-09-06 00:00:00 | -4 | -251.8
85076776 |  | -7 | -665
85076778 |  | -4 | -380
85074646 | 2012-08-31 00:00:00 | -0.5 | -47.5
85076752 |  | -2 | -152
85076756 |  | -2 | -151.84
85076776 |  | -3 | -285
85076778 | 2012-09-11 00:00:00 | -2.5 | -237.5
85074658 | 2012-08-30 00:00:00 | -3 | -188.85
85074662 |  | -11.5 | -672.75
85074663 | 2012-08-30 00:00:00 | -2 | -125.9
85074664 | 2012-08-30 00:00:00 | -6 | -377.7
85074666 | 2012-08-30 00:00:00 | -2 | -125.9
85074667 | 2012-08-30 00:00:00 | -2 | -125.9
85076744 |  | -54 | -3399.33
85076745 |  | -38.5 | -2423.59
85076746 |  | -59 | -3714.07
85076747 |  | -47.5 | -2778.75
85076748 |  | -19.5 | -1140.75
85076750 |  | -31.5 | -1982.93
85076751 |  | -38.5 | -2423.58
85076753 |  | -46 | -2691
85076752 | 2012-09-05 00:00:00 | -3.5 | -266
85076756 | 2012-09-05 00:00:00 | -4 | -303.68
85076759 | 2012-09-05 00:00:00 | -2 | -151.84
85076776 | 2012-09-05 00:00:00 | -4 | -380
85076778 | 2012-09-05 00:00:00 | -3.5 | -332.5
85076778 | 2012-09-05 00:00:00 | -1 | -95
85072951 | 2012-09-04 00:00:00 | 13 | 1100
85076759 | 2012-09-02 00:00:00 | 0.5 | 37.96
85074642 | 2012-08-30 00:00:00 | 1 | 72.5
85074646 | 2012-08-31 00:00:00 | 3.5 | 332.5
85074655 | 2012-08-30 00:00:00 | 6 | 351
85074658 | 2012-08-30 00:00:00 | 3 | 188.85
85074662 |  | 24.5 | 1433.25
85074663 | 2012-08-30 00:00:00 | 5 | 314.75
85074664 | 2012-08-30 00:00:00 | 6 | 377.7
85074666 | 2012-08-30 00:00:00 | 4 | 251.8
85074667 | 2012-08-30 00:00:00 | 4 | 251.8
85075950 | 2012-08-30 00:00:00 | 2 | 151.84
85076744 |  | 32 | 2014.4
85076745 |  | 45.5 | 2864.23
85076746 |  | 27 | 1699.66
85076747 |  | 38.5 | 2252.25
85076748 |  | 36 | 2106
85076749 |  | 14 | 1120
85076750 |  | 36.5 | 2297.69
85076751 |  | 41.5 | 2612.45
85076752 |  | 26 | 1976
85076753 |  | 40.5 | 2369.25
85076755 | 2012-09-06 00:00:00 | 2 | 145
85076756 |  | 17 | 1290.64
85076759 |  | 8.5 | 645.32
85076776 |  | 17 | 1615
85076778 |  | 28.5 | 2707.5
85074642 | 2012-08-31 00:00:00 | 3 | 217.5
85074646 | 2012-08-30 00:00:00 | 12.5 | 1187.5
85074651 | 2012-08-30 00:00:00 | 14.5 | 1377.5
85074662 | 2012-09-11 00:00:00 | 1 | 58.5
85075950 | 2012-08-30 00:00:00 | 6 | 455.52
85075951 | 2012-08-30 00:00:00 | 10.5 | 797.16
85076744 | 2012-09-11 00:00:00 | 1 | 62.95
85076746 | 2012-09-11 00:00:00 | 1 | 62.95
85076747 | 2012-09-11 00:00:00 | 1 | 58.5
85076753 | 2012-09-11 00:00:00 | 1 | 58.5
85076755 |  | 3.5 | 253.75
85076759 | 2012-09-03 00:00:00 | 3 | 227.76
85076776 |  | 6 | 570
85076778 |  | 4.5 | 427.5
85076755 | 2012-09-11 00:00:00 | 4 | 290
85076778 |  | 1 | 95
85076755 | 2012-09-04 00:00:00 | 5 | 362.5
85074642 | 2012-08-31 00:00:00 | 5 | 362.5
85076752 | 2012-09-08 00:00:00 | 4.5 | 342
85076755 |  | 25 | 1812.5
85076759 | 2012-09-03 00:00:00 | 4 | 303.68
85076755 |  | 8 | 580
85076755 | 2012-09-07 00:00:00 | 9 | 652.5
85074642 |  | 7 | 507.5
85076755 |  | 5 | 362.5
85076756 |  | 5 | 379.6
85076759 |  | 4 | 303.68
85076776 |  | 9 | 855
85076778 | 2012-09-09 00:00:00 | 1 | 95
85074642 | 2012-08-30 00:00:00 | 2 | 145
85074661 | 2012-08-30 00:00:00 | 5 | 400
85076749 |  | 7.5 | 600
85076754 |  | 12 | 870
85074643 | 2012-08-30 00:00:00 | 7 | 507.5
85074661 | 2012-08-30 00:00:00 | 7 | 560
85076749 |  | 78 | 6240
85076754 |  | 57 | 4132.5
85074643 | 2012-08-30 00:00:00 | 3 | 217.5
85076749 | 2012-09-10 00:00:00 | 4 | 320
85076754 | 2012-09-01 00:00:00 | 3 | 217.5
85076778 | 2012-09-10 00:00:00 | 0.5 | 47.5
85076755 | 2012-09-11 00:00:00 | 4 | 290
85076778 | 2012-09-10 00:00:00 | 0.5 | 47.5
85074642 | 2012-08-30 00:00:00 | 1 | 72.5
85075950 | 2012-08-31 00:00:00 | 12 | 911.04
85075951 |  | 15 | 1138.8
85076752 | 2012-09-07 00:00:00 | 13.5 | 1026
85076755 | 2012-09-03 00:00:00 | 4 | 290
85076756 |  | 21 | 1594.32
85076759 |  | 24 | 1822.08
85076752 | 2012-09-10 00:00:00 | 4 | 304
85076755 |  | 5 | 362.5
85076752 | 2012-09-08 00:00:00 | 0.5 | 38
85076755 |  | 12 | 870
85074642 | 2012-08-30 00:00:00 | 3 | 217.5
85076752 | 2012-09-10 00:00:00 | 2 | 152
85076776 |  | 6.5 | 617.5
85076759 | 2012-09-05 00:00:00 | 3 | 227.76
85076776 | 2012-09-05 00:00:00 | 3 | 285
85076752 | 2012-09-09 00:00:00 | 0.5 | 38
85076759 | 2012-09-02 00:00:00 | 0.5 | 37.96
85076752 | 2012-09-09 00:00:00 | 1 | 76
85076759 | 2012-09-02 00:00:00 | 0.5 | 37.96
85076755 | 2012-09-02 00:00:00 | 2 | 145
85076756 | 2012-09-04 00:00:00 | 2 | 151.84
85076759 | 2012-09-04 00:00:00 | 4 | 303.68
85076755 | 2012-09-03 00:00:00 | 1 | 72.5
85076778 | 2012-09-08 00:00:00 | 2.5 | 237.5
85076755 | 2012-09-03 00:00:00 | 1 | 72.5
85076755 | 2012-09-03 00:00:00 | 1 | 72.5
85076755 | 2012-09-03 00:00:00 | 1 | 72.5
85076776 | 2012-09-01 00:00:00 | 1 | 95
85076776 | 2012-09-01 00:00:00 | 1 | 95
85075952 | 2012-08-30 00:00:00 | 10.5 | 798
85074642 | 2012-08-30 00:00:00 | 1 | 72.5
85076778 | 2012-09-09 00:00:00 | 1 | 95
85076778 | 2012-09-07 00:00:00 | 0.75 | 71.25
85076778 | 2012-09-07 00:00:00 | 0.75 | 71.25
85076776 | 2012-09-04 00:00:00 | 0.5 | 47.5
85076755 |  | 2 | 145
85076749 |  | 10 | 800
85076752 | 2012-09-06 00:00:00 | 14 | 1064
85076778 |  | 15.5 | 1472.5
85076778 | 2012-09-09 00:00:00 | 0.5 | 47.5
85074642 | 2012-08-30 00:00:00 | 1 | 72.5
85076755 |  | 7 | 507.5
85076759 | 2012-09-02 00:00:00 | 2 | 151.84
85076778 | 2012-09-09 00:00:00 | 2 | 190
85076748 | 2012-09-04 00:00:00 | 1 | 58.5
85076755 | 2012-09-03 00:00:00 | 1 | 72.5
85076756 | 2012-09-01 00:00:00 | 1 | 75.92
85076759 | 2012-09-01 00:00:00 | 0.5 | 37.96
85076756 | 2012-09-01 00:00:00 | 1 | 75.92
85076759 | 2012-09-01 00:00:00 | 0.5 | 37.96
85076756 | 2012-09-01 00:00:00 | 1 | 75.92
85076759 | 2012-09-01 00:00:00 | 0.5 | 37.96
85076778 | 2012-09-08 00:00:00 | 0.5 | 47.5
85076756 | 2012-09-01 00:00:00 | 1 | 75.92
85076759 | 2012-09-01 00:00:00 | 0.5 | 37.96
85076778 | 2012-09-08 00:00:00 | 0.5 | 47.5
85076756 | 2012-09-05 00:00:00 | 4 | 303.68
85076778 | 2012-09-10 00:00:00 | 2 | 190
85076752 | 2012-09-09 00:00:00 | 1 | 76
85076759 | 2012-09-02 00:00:00 | 1 | 75.92
85076776 |  | 4 | 380
85076778 |  | 3 | 285
85076752 | 2012-09-09 00:00:00 | 2 | 152
85076778 | 2012-09-07 00:00:00 | 2.5 | 237.5
85075950 | 2012-08-30 00:00:00 | 4 | 303.68
85076750 | 2012-09-06 00:00:00 | 4 | 251.8
85076751 | 2012-09-06 00:00:00 | 4 | 251.8
85076776 |  | 7 | 665
85076778 |  | 4 | 380
85076752 |  | 1.5 | 114
85076756 |  | 2 | 151.84
85076776 |  | 3 | 285
85074658 | 2012-08-30 00:00:00 | 3 | 188.85
85074662 |  | 11.5 | 672.75
85074663 | 2012-08-30 00:00:00 | 2 | 125.9
85074664 | 2012-08-30 00:00:00 | 6 | 377.7
85074666 | 2012-08-30 00:00:00 | 2 | 125.9
85074667 | 2012-08-30 00:00:00 | 2 | 125.9
85076744 |  | 54 | 3399.33
85076745 |  | 38.5 | 2423.59
85076746 |  | 59 | 3714.07
85076747 |  | 47.5 | 2778.75
85076748 |  | 19.5 | 1140.75
85076750 |  | 31.5 | 1982.93
85076751 |  | 38.5 | 2423.58
85076753 |  | 46 | 2691
85076752 | 2012-09-05 00:00:00 | 3.5 | 266
85076756 | 2012-09-05 00:00:00 | 4 | 303.68
85076759 | 2012-09-05 00:00:00 | 2 | 151.84
85076776 | 2012-09-05 00:00:00 | 4 | 380
85076778 | 2012-09-05 00:00:00 | 3.5 | 332.5
85076778 | 2012-09-05 00:00:00 | 1 | 95
85072951 | 2012-09-28 00:00:00 | 0 | 140
85072951 | 2012-09-28 00:00:00 | 0 | 195
85075951 | 2012-09-28 00:00:00 | 0 | 0.01
85072951 | 2012-09-28 00:00:00 | 0 | -45
85072951 | 2012-09-28 00:00:00 | 0 | 260
85075951 | 2012-09-28 00:00:00 | 0 | 0.01