Spreadsheet: 678872d1590089910-how-to-conditionally-format-pivot-table-2020-05-21-oeldere-jlblackburn-pt-678828d1590077053-how-to-conditionally-format-pivot-table-
Sheet: Pivot

 | Kolomlabels
 | 2020-05-20 00:00:00 |  | 2020-05-16 00:00:00 |  | 2020-05-15 00:00:00 |  | 2020-05-13 00:00:00 |  | 2020-05-12 00:00:00
SYM | Sum of Market Value | differance day 20/5 -16/5 | Sum of Market Value | differance day 20/5 -16/5 | Sum of Market Value | differance day 20/5 -16/5 | Sum of Market Value | differance day 20/5 -16/5 | Sum of Market Value | differance day 20/5 -16/5
A1 | 9800.45 |  | 9156.89 | -643.5600000000013 | 9158.62 | -641.8299999999999 | 8885.28 | -915.1700000000001 | 4666.26 | -5134.190000000001
A10 | 4456 |  | 4230 | -226 | 4247 | -209 | 4262 | -194 | 4444 | -12
A11 | 2236.52 |  | 1993.42 | -243.0999999999999 | 1989 | -247.52 | 2079.61 | -156.9099999999999 | 2234.31 | -2.210000000000036
A12 | 3829.65 |  | 3618.65 | -211 | 3617.6 | -212.0500000000002 | 3808.55 | -21.09999999999991 | 4018.5 | 188.8499999999999
A13 | 4910 |  | 4864 | -46 | 4890 | -20 | 4903.76 | -6.239999999999782 | 4918 | 8
A14 | 10075.98 |  | 9272 | -803.9799999999996 | 9369.6 | -706.3799999999992 | 8789.29 | -1286.689999999999 | 3570.16 | -6505.82
A15 | 13004.04 |  | 12286.16 | -717.880000000001 | 12302.6 | -701.4400000000005 | 12439.6 | -564.4400000000005 | 8634.6 | -4369.440000000001
A16 | 3213.54 |  | 3111.46 | -102.0799999999999 | 3025.88 | -187.6599999999999 | 3151.61 | -61.92999999999984 | 3267.22 | 53.67999999999984
A17 | 9470.89 |  | 9370.4 | -100.4899999999998 | 9341.28 | -129.6099999999988 | 9467.9 | -2.989999999999782 | 7241.28 | -2229.61
A18 | 4249.7 |  | 4007.9 | -241.7999999999997 | 3866.2 | -383.5 | 3969.55 | -280.1499999999996 | 4197.7 | -52
A19 | 8599.05 |  | 8253.81 | -345.2399999999998 | 8228.77 | -370.2799999999988 | 8299.2 | -299.8499999999985 | 8478.58 | -120.4699999999993
A2 | 5277.98 |  | 5170 | -107.9799999999996 | 5200 | -77.97999999999956 | 5282 | 4.020000000000437 | 5342 | 64.02000000000044
A20 | 9970.2 |  | 9095.42 | -874.7800000000007 | 8890.1 | -1080.1 | 8910.15 | -1060.050000000001 | 4777.55 | -5192.650000000001
A21 | 7507.8 |  | 7092.64 | -415.1599999999999 | 6902.04 | -605.7600000000002 | 6818.13 | -689.6700000000001 | 4750.83 | -2756.97
A22 | 5338 |  | 5182 | -156 | 5195 | -143 | 5168 | -170 | 5170 | -168
A23 | 5416 |  | 5354 | -62 | 5346 | -70 | 5352 | -64 | 5400.4 | -15.60000000000036
A24 | 2953.06 |  | 2720.56 | -232.5 | 2683.36 | -269.6999999999998 | 2667.24 | -285.8200000000002 | 2750.32 | -202.7399999999998
A25 | 9830.98 |  | 9917.08 | 86.10000000000036 | 9998.26 | 167.2800000000007 | 9753.9 | -77.07999999999993 | 8447.66 | -1383.32
A26 | 2150 |  | 2139 | -11 | 2160 | 10 | 2175 | 25 | 2218 | 68
A27 | 7708.78 |  | 7467.95 | -240.8299999999999 | 7433.75 | -275.0299999999997 | 7088.9 | -619.8800000000001 | 4841.57 | -2867.21
A28 | 3849.8 |  | 3662 | -187.8000000000002 | 3656 | -193.8000000000002 | 3746 | -103.8000000000002 | 3986 | 136.1999999999998
A29 | 10149.44 |  | 8597.12 | -1552.32 | 8624 | -1525.440000000001 | 8736 | -1413.440000000001 | 3200.9 | -6948.540000000001
A3 | 3106.75 |  | 2991.49 | -115.2600000000002 | 2965.65 | -141.0999999999999 | 3017.5 | -89.25 | 3010.02 | -96.73000000000002
A30 | 7903.05 |  | 7204.63 | -698.4200000000001 | 7290.64 | -612.4099999999999 | 6841.09 | -1061.96 | 4740 | -3163.05
A31 | 7369.5 |  | 7041.75 | -327.75 | 6939 | -430.5 | 7012.5 | -357 | 4670.4 | -2699.1
A32 | 4154 |  | 3777.04 | -376.96 | 3697.08 | -456.9200000000001 | 3731.38 | -422.6199999999999 | 3977.92 | -176.0799999999999
A33 | 4878.2 |  | 4786 | -92.19999999999982 | 4850 | -28.19999999999982 | 4910 | 31.80000000000018 | 5100 | 221.8000000000002
A34 | 4953.98 |  | 4676 | -277.9799999999996 | 4756 | -197.9799999999996 | 4902 | -51.97999999999956 | 4962 | 8.020000000000437
[NAME] | 4598 |  | 4430 | -168 | 4439.98 | -158.0200000000004 | 4415 | -183 | 4440.68 | -157.3199999999997
A36 | 4152.48 |  | 3997.44 | -155.0399999999995 | 3955.68 | -196.7999999999997 | 3989.28 | -163.1999999999994 | 4151.52 | -0.9599999999991269
A37 | 10038.6 |  | 9449 | -589.6000000000004 | 9447.9 | -590.7000000000007 | 9241.1 | -797.5 | 5512.11 | -4526.490000000001
A38 | 4230 |  | 4190 | -40 | 4250 | 20 | 4357.62 | 127.6199999999999 | 4504.12 | 274.1199999999999
A39 | -35 |  | -44 | -9 | -32 | 3 | -46.5 | -11.5 | -28.5 | 6.5
A4 | 3039.4 |  | 2823.6 | -215.8000000000002 | 2816.45 | -222.9500000000003 | 2932.8 | -106.5999999999999 | 3153.8 | 114.4000000000001
A40 | 7324.81 |  | 7077.33 | -247.4800000000005 | 6999.74 | -325.0700000000006 | 7013.39 | -311.4200000000001 | 4778.55 | -2546.26
A41 | 10084.36 |  | 9308.64 | -775.7200000000012 | 9239.84 | -844.5200000000004 | 9306.92 | -777.4400000000005 | 6537.9 | -3546.460000000001
A42 | 5080 |  | 5100 | 20 | 5090 | 10 | 5052 | -28 | 5094.6 | 14.60000000000036
A43 | 5383.18 |  | 5250 | -133.1800000000003 | 5289.04 | -94.14000000000033 | 5392 | 8.819999999999709 | 5454.6 | 71.42000000000007
[NAME] | 100297.24 |  | 96778.1 | -3519.139999999999 | 96003.96 | -4293.279999999999 | 94759.92 | -5537.320000000007 | 98904.46 | -1392.779999999999
A45 | 8320.88 |  | 7869.21 | -451.6699999999992 | 7970.26 | -350.619999999999 | 7668.99 | -651.8899999999994 | 7999.64 | -321.2399999999989
A46 | 7259.2 |  | 6874.8 | -384.3999999999996 | 6909.6 | -349.5999999999995 | 6884 | -375.1999999999998 | 4677.66 | -2581.54
A47 | 5400 |  | 5356 | -44 | 5365.4 | -34.60000000000036 | 5390 | -10 | 5452 | 52
A48 | 11567.76 |  | 10170.46 | -1397.300000000001 | 10095.1 | -1472.66 | 9479.66 | -2088.1 | 3271.33 | -8296.43
A49 | 5312 |  | 5280 | -32 | 5280 | -32 | 5353 | 41 | 5392 | 80
A5 | 3634.4 |  | 3277.4 | -357 | 3151.4 | -483 | 3206 | -428.4000000000001 | 3716.3 | 81.90000000000009
[NAME] | 8278.2 |  | 8652.15 | 373.9499999999989 | 8758.13 | 479.9299999999985 | 8496.23 | 218.0299999999988 | 8631.9 | 353.6999999999989
A51 | 9492 |  | 9574.25 | 82.25 | 9545.38 | 53.3799999999992 | 9589.13 | 97.1299999999992 | 6890.46 | -2601.54
A52 | 3014.38 |  | 3007.71 | -6.670000000000073 | 2985.98 | -28.40000000000009 | 3055.32 | 40.94000000000005 | 3136.74 | 122.3599999999997
A53 | 5374 |  | 5324 | -50 | 5324 | -50 | 5340 | -34 | 5376 | 2
[NAME] | 10118.32 |  | 9120 | -998.3199999999997 | 9100.24 | -1018.08 | 9189.16 | -929.1599999999999 | 2827.66 | -7290.66
A55 | 3467.04 |  | 3181.84 | -285.1999999999998 | 3152.7 | -314.3400000000001 | 3160.14 | -306.9000000000001 | 3465.18 | -1.860000000000127
[NAME] | 3497.01 |  | 3239.61 | -257.4000000000001 | 3193.08 | -303.9300000000003 | 3272.61 | -224.4000000000001 | 3501.3 | 4.289999999999964
A57 | 0.05 |  | 0.05 | 0 | 0.05 | 0 | 0.05 | 0 | 0.05 | 0
A58 | 13933.44 |  | 13101.54 | -831.8999999999996 | 13032.51 | -900.9300000000003 | 12537.28 | -1396.16 | 9212.22 | -4721.220000000001
A6 | 9948.54 |  | 10051.86 | 103.3199999999997 | 9989.7 | 41.15999999999985 | 9660.84 | -287.7000000000007 | 7654.72 | -2293.820000000001
A60 | 3219.64 |  | 3214.12 | -5.519999999999982 | 3153.5 | -66.13999999999987 | 3227.84 | 8.200000000000273 | 3286.64 | 67
A61 | 5194 |  | 5138 | -56 | 5172 | -22 | 5161 | -33 | 5160 | -34
A62 | 13297.37 |  | 13251.49 | -45.88000000000102 | 13002.47 | -294.9000000000015 | 99108.11 | 85810.74 | 14985.21 | 1687.839999999998
A63 | 7478.13 |  | 6802.17 | -675.96 | 6691.23 | -786.9000000000005 | 6972.45 | -505.6800000000003 | 3133.89 | -4344.24
A64 | 2885 |  | 2515 | -370 | 2475 | -410 | 2372.5 | -512.5 | 2535 | -350
A65 | 5464 |  | 5279 | -185 | 5344 | -120 | 5424.16 | -39.84000000000015 | 5642 | 178
A66 | 8269.5 |  | 7921.7 | -347.8000000000002 | 7893.95 | -375.5500000000002 | 7959.44 | -310.0600000000004 | 8164.05 | -105.4499999999998
A67 | 5250 |  | 5144 | -106 | 5150 | -100 | 5205.9 | -44.10000000000036 | 5253.92 | 3.920000000000073
A68 | 5300 |  | 5158 | -142 | 5184 | -116 | 5120.78 | -179.2200000000003 | 5186.38 | -113.6199999999999
A69 | 5052.98 |  | 5056 | 3.020000000000437 | 5037.7 | -15.27999999999975 | 5046 | -6.979999999999563 | 5122 | 69.02000000000044
A7 | 4728 |  | 4672.18 | -55.81999999999971 | 4692 | -36 | 4790.12 | 62.11999999999989 | 4922 | 194
A70 | 3096.4 |  | 3007 | -89.40000000000009 | 2936.35 | -160.0500000000002 | 3009.4 | -87 | 3091.6 | -4.800000000000182
[NAME] | 3293.34 |  | 3023.48 | -269.8600000000001 | 2897.72 | -395.6200000000003 | 2844.01 | -449.3299999999999 | 3227.84 | -65.5
A72 | 10428.72 |  | 10093.56 | -335.1599999999999 | 10029.72 | -399 | 9499.62 | -929.0999999999985 | 7817.76 | -2610.959999999999
A73 | 9425.41 |  | 9433.84 | 8.430000000000291 | 9423.44 | -1.969999999999345 | 9186.32 | -239.0900000000001 | 9510.17 | 84.76000000000022
A74 | 5104 |  | 4946 | -158 | 4970 | -134 | 5065.64 | -38.35999999999967 | 5136 | 32
A75 | 4940 |  | 4828 | -112 | 4808 | -132 | 4850 | -90 | 4980 | 40
A76 | 7703.49 |  | 7168.44 | -535.0500000000002 | 7088.49 | -615 | 7051.59 | -651.8999999999996 | 4812 | -2891.49
A77 | 5390 |  | 5356 | -34 | 5382.56 | -7.4399999999996 | 5516 | 126 | 5558 | 168
A8 | 8664.38 |  | 9127.6 | 463.2200000000012 | 9084.09 | 419.7100000000009 | 9019.3 | 354.9200000000001 | 9260.98 | 596.6000000000004
A9 | 3012.57 |  | 2913.63 | -98.94000000000005 | 2836.37 | -176.2000000000003 | 2986.05 | -26.51999999999998 | 3078.87 | 66.29999999999973
Eindtotaal | 566370.5599999999 |  | 543529.57 | -22840.98999999999 | 541230.1399999999 | -25140.42000000004 | 624280.31 | 57909.75000000012 | 476589.4899999999 | -89781.07000000007