4. Starting with the Sales Data file, write a sub that uses a For Each loop to italicize and change the cell interior color to blue for each sales amount that is greater than $10,200. Sales Data Q- Search Sheet Home Insert Page Layout Formulas Data Review View Developer 11 AutoSum , Calibri 11 A- A Wrap Text General 0, IX H Fill Paste B I U A Merge & Center $ 2.0 .00 .00 ..0 Insert Delete Format Conditional Format Formatting as Table Cell Styles Clear A1 fx A B D E F H 1 J L M N O P Q R s T U V w G Jun 8169 Jan 13531 14399 9118 Apr 13589 14419 6826 5005 8652 12194 14547 9590 12279 8118 14864 13809 10023 10941 8310 14097 6406 10275 13237 13143 9104 Jul 8907 7679 6725 13795 10812 12141 6021 14481 6601 12928 11559 12369 11999 6092 1 2 Region 1 3 Region 2 4 Region 3 5 Region 4 6 Region 5 7 Region 6 8 Region 7 9 Region 8 10 Region 9 11 Region 10 12 Region 11 13 Region 12 14 Region 13 15 Region 14 16 Region 15 17 Region 16 18 Region 17 19 Region 18 20 Region 19 21 Region 20 22 Region 21 23 Region 22 24 Region 23 25 Region 24 26 Region 25 27 Region 26 28 Region 27 29 Region 28 30 Region 29 31 Region 30 32 Region 31 33 Region 32 34 Region 33 35 Region 34 36 Region 35 37 Region 36 38 Region 37 39 Region 38 40 Region 39 41 Region 40 42 43 5680 8511 11438 5089 13322 9324 6485 8712 11725 14101 12234 6424 11916 12222 12630 10930 8722 5788 13578 10342 10016 9306 10849 13255 13022 11410 6609 8489 7447 9140 7807 8629 9608 6675 5566 14948 12316 Feb 7014 8438 14837 14382 7202 14922 8035 10581 5997 8434 5087 8227 9371 13536 14854 11230 8437 8083 9680 11606 8192 7965 12582 6307 13890 10633 7948 12090 5631 6186 12704 5682 6709 6289 10103 10997 12171 5313 5990 14217 Mar 5678 11724 6229 8143 12166 8586 10394 14055 8536 10843 9580 14551 9974 10785 11627 13903 13466 10381 11159 12747 10351 6297 12354 8748 11957 12150 12879 6620 6134 14997 12481 9049 7454 8588 8539 11092 12561 14454 6483 8572 8622 10506 14850 5558 5944 6789 9581 12091 12344 14572 5029 8855 10196 5490 13829 8637 9813 May 5357 7854 10611 13596 12145 14748 13571 5156 14892 9517 13184 9166 11616 9013 5920 12882 6870 11680 12177 12068 12646 6040 8737 7026 10989 8441 9481 7452 13445 12149 7373 11922 9904 7871 10819 11016 5345 14732 5775 14346 9343 12095 8338 13288 10260 13231 13962 7467 10904 14094 13585 13635 8879 11955 7930 12418 9321 6584 10949 6618 13039 10877 10601 9735 14219 6600 13334 13974 14277 9914 9770 11523 13202 8435 6365 7636 12840 5980 6058 9473 11795 9918 11350 13702 9339 5045 12108 12508 12654 5775 11494 13143 11339 5466 14552 8181 12219 6730 12119 10842 7176 6387 11462 Aug 14055 14472 14304 14087 9329 9007 9244 8532 11043 10607 5650 12897 9877 9401 8475 13853 14582 12699 10555 7182 9667 14645 6490 12322 12848 9851 9651 13387 5637 6580 6568 6201 6481 10512 10701 6518 6473 11148 8770 5958 Sep 5751 11185 12708 9826 9375 11647 7508 6871 5209 10149 10163 9152 13700 12778 7053 14637 7667 6347 10359 11096 11578 11946 7903 11267 12225 13106 5364 8576 6544 12126 10004 13081 7775 11935 13790 10483 12426 5068 13074 12277 Oct 5254 7053 8687 14107 11046 5647 9103 5282 12439 11697 5349 12908 10845 10259 8021 6327 10844 7279 14040 12986 5154 7943 8546 5101 12388 11420 12635 5308 10489 14528 11261 5925 12255 5915 9633 6314 9992 12832 13610 8871 Nov 13383 13263 10696 12550 9954 8972 5938 8692 12237 10194 8428 8830 14601 11825 7691 14499 14414 10179 12024 9163 7128 8623 10475 13896 12351 6744 9356 9504 9484 8359 11451 12113 7324 8487 11090 11726 14593 8652 14817 9376 Dec 9445 13913 6824 14945 11194 10431 14306 13436 9875 9934 7101 8087 10362 8382 11656 12195 8232 9856 5406 8781 11393 11278 5427 11518 13019 8551 8825 8435 8217 13257 6059 8649 8696 8524 8599 14547 14752 11889 13794 7313 5687 14983 9544 8309 Data + Ready T 4. Starting with the Sales Data file, write a sub that uses a For Each loop to italicize and change the cell interior color to blue for each sales amount that is greater than $10,200. Sales Data Q- Search Sheet Home Insert Page Layout Formulas Data Review View Developer 11 AutoSum , Calibri 11 A- A Wrap Text General 0, IX H Fill Paste B I U A Merge & Center $ 2.0 .00 .00 ..0 Insert Delete Format Conditional Format Formatting as Table Cell Styles Clear A1 fx A B D E F H 1 J L M N O P Q R s T U V w G Jun 8169 Jan 13531 14399 9118 Apr 13589 14419 6826 5005 8652 12194 14547 9590 12279 8118 14864 13809 10023 10941 8310 14097 6406 10275 13237 13143 9104 Jul 8907 7679 6725 13795 10812 12141 6021 14481 6601 12928 11559 12369 11999 6092 1 2 Region 1 3 Region 2 4 Region 3 5 Region 4 6 Region 5 7 Region 6 8 Region 7 9 Region 8 10 Region 9 11 Region 10 12 Region 11 13 Region 12 14 Region 13 15 Region 14 16 Region 15 17 Region 16 18 Region 17 19 Region 18 20 Region 19 21 Region 20 22 Region 21 23 Region 22 24 Region 23 25 Region 24 26 Region 25 27 Region 26 28 Region 27 29 Region 28 30 Region 29 31 Region 30 32 Region 31 33 Region 32 34 Region 33 35 Region 34 36 Region 35 37 Region 36 38 Region 37 39 Region 38 40 Region 39 41 Region 40 42 43 5680 8511 11438 5089 13322 9324 6485 8712 11725 14101 12234 6424 11916 12222 12630 10930 8722 5788 13578 10342 10016 9306 10849 13255 13022 11410 6609 8489 7447 9140 7807 8629 9608 6675 5566 14948 12316 Feb 7014 8438 14837 14382 7202 14922 8035 10581 5997 8434 5087 8227 9371 13536 14854 11230 8437 8083 9680 11606 8192 7965 12582 6307 13890 10633 7948 12090 5631 6186 12704 5682 6709 6289 10103 10997 12171 5313 5990 14217 Mar 5678 11724 6229 8143 12166 8586 10394 14055 8536 10843 9580 14551 9974 10785 11627 13903 13466 10381 11159 12747 10351 6297 12354 8748 11957 12150 12879 6620 6134 14997 12481 9049 7454 8588 8539 11092 12561 14454 6483 8572 8622 10506 14850 5558 5944 6789 9581 12091 12344 14572 5029 8855 10196 5490 13829 8637 9813 May 5357 7854 10611 13596 12145 14748 13571 5156 14892 9517 13184 9166 11616 9013 5920 12882 6870 11680 12177 12068 12646 6040 8737 7026 10989 8441 9481 7452 13445 12149 7373 11922 9904 7871 10819 11016 5345 14732 5775 14346 9343 12095 8338 13288 10260 13231 13962 7467 10904 14094 13585 13635 8879 11955 7930 12418 9321 6584 10949 6618 13039 10877 10601 9735 14219 6600 13334 13974 14277 9914 9770 11523 13202 8435 6365 7636 12840 5980 6058 9473 11795 9918 11350 13702 9339 5045 12108 12508 12654 5775 11494 13143 11339 5466 14552 8181 12219 6730 12119 10842 7176 6387 11462 Aug 14055 14472 14304 14087 9329 9007 9244 8532 11043 10607 5650 12897 9877 9401 8475 13853 14582 12699 10555 7182 9667 14645 6490 12322 12848 9851 9651 13387 5637 6580 6568 6201 6481 10512 10701 6518 6473 11148 8770 5958 Sep 5751 11185 12708 9826 9375 11647 7508 6871 5209 10149 10163 9152 13700 12778 7053 14637 7667 6347 10359 11096 11578 11946 7903 11267 12225 13106 5364 8576 6544 12126 10004 13081 7775 11935 13790 10483 12426 5068 13074 12277 Oct 5254 7053 8687 14107 11046 5647 9103 5282 12439 11697 5349 12908 10845 10259 8021 6327 10844 7279 14040 12986 5154 7943 8546 5101 12388 11420 12635 5308 10489 14528 11261 5925 12255 5915 9633 6314 9992 12832 13610 8871 Nov 13383 13263 10696 12550 9954 8972 5938 8692 12237 10194 8428 8830 14601 11825 7691 14499 14414 10179 12024 9163 7128 8623 10475 13896 12351 6744 9356 9504 9484 8359 11451 12113 7324 8487 11090 11726 14593 8652 14817 9376 Dec 9445 13913 6824 14945 11194 10431 14306 13436 9875 9934 7101 8087 10362 8382 11656 12195 8232 9856 5406 8781 11393 11278 5427 11518 13019 8551 8825 8435 8217 13257 6059 8649 8696 8524 8599 14547 14752 11889 13794 7313 5687 14983 9544 8309 Data + Ready T