Starting with the original Sales Data.xlsx file from the previous exercise, write a sub that examines each row for upward or downward movements in quarterly totals. Specifically, for each row, check whether the quarterly totals increase each quarter and whether they decrease each quarter. If the former, color the region's label in column A red; if the latter, color it blue. Screenshot of " Sales Data .xlsm' worksheet Sale Date More het Genel Merge C. Cantina Toma Formatting Dom ter Seed Font th A D 3 N o Alpe Now M Dec Feb 2011 34 5670 SET S 0 Jun 1309 9005 3:52 Jul 1907 7572 SOME SEYE 11724 2 Region 1 3 Region 2 4 Regio 3 Region 14419 7050 1402 9118 7854 10613 6229 8143 (705 CODE 100 110 DE 76 5111 TEOT 7200 ene 13095 511 11450 4 365 9990 UT re re Sagit TEGNE OG 2006 LE Region Bagian! Root TRE PER err 301 1234 6021 1481 BAND STI 5150 POT 9044 3931 CROS re CANE 140 wer 14055 1333 10000 11933 CES 1871 re SW 100 MT DO CHE w COLE 9513 OS SPOT CET E 6 V 10 Region 11 Region 10 12 Region 11 13 Region 12 14 Regio 04 GAS 8712 11725 POT G 116 10000 5650 1303) ROS MIT 2016 UPS re - 7100 30035 304 8321 14554 9106 7407 10504 14054 25 1359 12 18 CSTG 12 1085 CROE CERE ST SHOE 100 2 VLOE 15 Region 16 Begins For the per color 1 SIS 700 NOVO ST SERET Los SCH 3800 120 127 7055 sam 11650 . 12195 11910 SEES 3120 BEST SON 50 6058 473 PTT 32 11955 re 13231 627 1044 1.3853 14543 76 num 1 101 1115 14414 101 C CE WE 954 10555 19 VOT 05 LICE SORT TOTT MOT POT 916 PEET CUTE MOT GTR 134 9033 6564 109 OSETT COLET LON 1157 3780 1005 1264 3154 7131 13 931 3050 14850 SS 9063 14645 EN 17 Region 18 Region 11 To Be 30 Region 19 21 Region 20 22 Regione 21 ve 24 Region 23 35 Region 20 Regions 22 Region 21 Region Rego 10 Region 31 Region IT III CIDE BI 0979 . STS SMOT URE UNSE COOLT 22001 LOTS 1001 9306 10545 12345 UIT TUTT 675 191T STOIT LO 3441 15 6 11953 12150 13 10077 10000 TRS 18 Region want 21 SES sun SRR SER SRL wan BE 1410 600 TIT 361 HETO 6 SH 34572 902 O 10 w CEPT 1145 el WTP WE POUZE res rose PECHE C SON IS US 23 som ST 12120 DI PORT 100 Regen SOS 300 313 5576 es M 9140 CIN 16 LORE VE 6700 PH 1046 be 14 11914 14:37 See 5020 11523 11202 1056 33 15 Region 36 Region COS 704 754 1580 6 OS SCRET 12215 sus 2.2.35 3915 7775 11535 1370 CAT POR en CORT 2010 10512 10000 re 7873 10815 11010 CES 3637 11030 re ar re 8390 14 70 6314 w 327 CE SPIS Region Day ople CSV 6675 ss I! DV 99 SETE SPES TIS 1454 COPE 1231 . 33 7375 6387 13453 1134 306 CAT NOT 954 OLOR MONT 13610 14812 377 1440 7636 12140 12310 14211 5956 an 7813 NE Short 52 Starting with the original Sales Data.xlsx file from the previous exercise, write a sub that examines each row for upward or downward movements in quarterly totals. Specifically, for each row, check whether the quarterly totals increase each quarter and whether they decrease each quarter. If the former, color the region's label in column A red; if the latter, color it blue. Screenshot of " Sales Data .xlsm' worksheet Sale Date More het Genel Merge C. Cantina Toma Formatting Dom ter Seed Font th A D 3 N o Alpe Now M Dec Feb 2011 34 5670 SET S 0 Jun 1309 9005 3:52 Jul 1907 7572 SOME SEYE 11724 2 Region 1 3 Region 2 4 Regio 3 Region 14419 7050 1402 9118 7854 10613 6229 8143 (705 CODE 100 110 DE 76 5111 TEOT 7200 ene 13095 511 11450 4 365 9990 UT re re Sagit TEGNE OG 2006 LE Region Bagian! Root TRE PER err 301 1234 6021 1481 BAND STI 5150 POT 9044 3931 CROS re CANE 140 wer 14055 1333 10000 11933 CES 1871 re SW 100 MT DO CHE w COLE 9513 OS SPOT CET E 6 V 10 Region 11 Region 10 12 Region 11 13 Region 12 14 Regio 04 GAS 8712 11725 POT G 116 10000 5650 1303) ROS MIT 2016 UPS re - 7100 30035 304 8321 14554 9106 7407 10504 14054 25 1359 12 18 CSTG 12 1085 CROE CERE ST SHOE 100 2 VLOE 15 Region 16 Begins For the per color 1 SIS 700 NOVO ST SERET Los SCH 3800 120 127 7055 sam 11650 . 12195 11910 SEES 3120 BEST SON 50 6058 473 PTT 32 11955 re 13231 627 1044 1.3853 14543 76 num 1 101 1115 14414 101 C CE WE 954 10555 19 VOT 05 LICE SORT TOTT MOT POT 916 PEET CUTE MOT GTR 134 9033 6564 109 OSETT COLET LON 1157 3780 1005 1264 3154 7131 13 931 3050 14850 SS 9063 14645 EN 17 Region 18 Region 11 To Be 30 Region 19 21 Region 20 22 Regione 21 ve 24 Region 23 35 Region 20 Regions 22 Region 21 Region Rego 10 Region 31 Region IT III CIDE BI 0979 . STS SMOT URE UNSE COOLT 22001 LOTS 1001 9306 10545 12345 UIT TUTT 675 191T STOIT LO 3441 15 6 11953 12150 13 10077 10000 TRS 18 Region want 21 SES sun SRR SER SRL wan BE 1410 600 TIT 361 HETO 6 SH 34572 902 O 10 w CEPT 1145 el WTP WE POUZE res rose PECHE C SON IS US 23 som ST 12120 DI PORT 100 Regen SOS 300 313 5576 es M 9140 CIN 16 LORE VE 6700 PH 1046 be 14 11914 14:37 See 5020 11523 11202 1056 33 15 Region 36 Region COS 704 754 1580 6 OS SCRET 12215 sus 2.2.35 3915 7775 11535 1370 CAT POR en CORT 2010 10512 10000 re 7873 10815 11010 CES 3637 11030 re ar re 8390 14 70 6314 w 327 CE SPIS Region Day ople CSV 6675 ss I! DV 99 SETE SPES TIS 1454 COPE 1231 . 33 7375 6387 13453 1134 306 CAT NOT 954 OLOR MONT 13610 14812 377 1440 7636 12140 12310 14211 5956 an 7813 NE Short 52
