Spreadsheet: 802553d1666904885-condition-formatting-formula-sample_102722
Sheet: Sample

Level 2 | YTD Current | YTD Current USD | Budget (Fav)/Unfav USD | Sum of % Variance to Budget (Fav)/Unfav USD | YTD Actuals | Previous Actuals (Fav)/Unfav
Line 1 | 930760.7 | 6387002.13 | -5456241.4348 | -1.0340245 | 5691304 | -4760543.300000001
Line 2 | 58862052.270484 | 63246835.98999999 | -4384783.716220799 | -0.3613060000000001 | 60267121 | -1405068.729516
Line 3 | 17008261.96 | 24564776.72 | -7556514.752988201 | -4.1732766 | 23099964 | -6091702.039999999
Line 4 | 4092994.636964001 | 5273412.75 | -1180418.113036 | -0.2538758000000001 | 10332153.02 | -6239158.383036001
Line 5 | 1558074.52 | 2005000 | -446925.48 | -0.781329 | 1711730 | -153655.48
Line 6 | 70459.55 | 140000 | -69540.45 | -0.4967175 | 103129 | -32669.45
Line 7 | 2211804.271462 | 3022185.64 | -810381.3728509 | -0.2681441 | 2185454 | 26350.271462
Line 8 | 3590068.696534 | 3553866 | 36202.6965349 | -1.0454737 | 2931299.99 | 658768.706534
Line 9 | 291441.378814 | 341682.48 | -50241.102059 | -0.8441926 | 354988.01 | -63546.631186
Line 10 | 2153480.208914 | 2073937.87 | 79542.33942860001 | 0.2028662 | 1664942 | 488538.2089140001
Line 11 | 32148.985297 | 35288.24 | -3139.2537018 | -0.0889603 | 31260 | 888.985297
Line 12 | 2433405.315909 | 2638192.65 | -204787.334446 | -0.1347273 | 943565.99 | 1489839.325909
Line 13 | 649177.0267599999 | 51543.81000000003 | 597633.2112153999 | -1.6603558 | 245512.02 | 403665.0067600001
Line 14 | 6546145.470656001 | 4960698.340000001 | 1585447.1296958 | 4.631548599999999 | 5381169 | 1164976.470656
Line 15 | 5402225.708730999 | 4484663.03 | 917562.6900754999 | -1.0415613 | 3238936 | 2163289.708731
Line 16 | 460555.22 | 342917.89 | 117637.3275114 | -0.2732131 | 334247 | 126308.22
Line 17 | 69525.86 | 96823.19 | -27297.3259037 | -0.2819296 | 207080 | -137554.14
Line 18 | 17016088.405345 | 16171363.39 | 844725.000849 | 0.6568078000000002 | 15189807 | 1826281.405345
Line 19 | 546406.591031 | 525538.92 | 20867.6696544 | 0.0397072 | 438006 | 108400.591031
Line 20 | 658214.63115 | 741815.81 | -83601.1781594 | -0.112698 | 669070.99 | -10856.35885
Line 21 | 2256314.4101 | 2377734.61 | -121420.1921788 | 0.1865214 | 2259369.99 | -3055.579900000001
Line 22 | 891102.113496 | 888926.35 | 2175.7664603 | 0.0024476 | 1214687 | -323584.886504
Line 23 | 18509144.645332 | 10556509.23 | 7952635.409238501 | 13.5229836 | 11821874 | 6687270.645331999
Line 24 | 7519.801218 | 42081.77 | -34561.9687817 | -0.5066848 | 39454.99 | -31935.188782
Line 25 | 3033195.156534 | 3447803.16 | -414608.0017188 | -0.9186702 | 612995 | 2420200.156534
Line 26 | 5455019.651745999 | 5743553.25 | -288533.6007235001 | -2.5239345 | 6060254 | -605234.348254
Line 27 | 4370419.447256001 | 4022228.52 | 348190.9271089 | 3.0730025 | 1314822 | 3055597.447256
Line 28 | 4260317.99 | 2748152.27 | 1512165.7300846 | -0.9669361 | 4378215 | -117897.01
Line 29 | -1875324 | -2889468.75 | 1014144.75 | -0.3509797 | -19486683 | 17611359
Line 30 | 5082127.855901 | 6272946.52 | -1190818.6637004 | -0.7022972000000001 | 24216294.01 | -19134166.154099
Line 31 | 18514153.21 | 16852979.38 | 1661173.8320291 | 4.6595944 | 15036538 | 3477615.21
Line 32 | 2639309.32227 | 2528584.05 | 110725.2714855 | -1.6321246 | 1936804.99 | 702504.3322699999
Line 33 | 2676323.524461 | 1688911.34 | 987412.1878094 | 4.2072063 | 1595677.99 | 1080645.534461
Line 34 | 18994339.728378 | 18006343.34 | 987996.3983437 | 4.1177003 | 14437373 | 4556966.728378
Line 35 | 22385.38071 | 29621.09 | -7235.706651 | -0.2442755 | 19242.01 | 3143.37071
Line 36 | 0.08 |  | 0.08 |  | 1012 | -1011.92
Greater Than or Equal to | 500000
Greater Than or Equal to | 0.1
Would like to take the ABS of the values in columns D & E