Macros: By using the visual edit in the developer, how do I edit the code to make sure the cntr command fills in all at once the "Central" region in blue-green? Please help with the coding. Thank you.

OO AutoSave OFF y Assignment 16.Smith 2 Home Insert Draw Page Layout Formulas Data Review View Developer Acrobat Tell me Share Comments Calibri (Body) :: ' V 11 Insert General ab V v HLV WE 8 DX Delete v Paste BIU FRV A Z Sort & Filter Y $ % ) V 98 99 Conditional Format Cell Formatting as Table Styles E Format v Find & Select Analyze Data Create and Share Adobe PDF W10 B D H K K L M N 0 P Q R S U V W 2 3 4 Order # # 123 124 125 I Total 202.28 1069.47 192.21 5 126 577.51 6 127 7 128 40 129 E Units 95 50 36 27 56 45 60 75 90 32 60 90 29 81 8 9 130 131 132 133 10 11 12 13 14 15 16 134 135 136 OrderDate Region 1/6/15 East 1/23/15 Central 2/9/15 Central 2/26/15 Central 3/15/15 West 3/29/15 West 4/1/15 East 4/18/15 Central 5/5/15 Central 5/22/15 West 6/8/15 East 6/25/15 Central 7/12/15 East 7/29/15 East 8/15/15 East Canto 9/1/15 Central 9/18/15 East 10/5/15 Central 10/22/15 East 11/8/15 East 11/25/15 Central 12/12/15 Central 12/29/15 East 1/15/16 Central 2/1/16 Central 2/18/16 East 3/7/16 West 3/24/16 Central 3/29/16 West 4/10/16 Central Alaska F G UnitCost Ext. Cost 1.99 189.05 19.99 999.5 4.99 179.64 19.99 539.73 2.99 167.44 2.99 134.55 4.99 299.4 1.99 149.25 4.99 449.1 1.99 63.68 8.99 539.4 4.99 449.1 1.99 57.71 19.99 1,619.19 4.99 174.65 125 250 15.99 255.84 8.99 251.72 57536 19.99 299.85 4.99 479.04 1.29 86.43 15.99 1,183.26 8.99 413-54 15 1,305.00 4.99 19.96 19.99 139.93 4.99 249.5 13.99 713 49 1.99 131.34 Item Pencil Binder Pencil Pen Pencil Binder Binder Pencil Pencil Pencil Binder Pencil Binder Binder Pencil Desk Pen Set Binder Pen Pen Pen Set Pencil Pen Set Binder Binder Binder Binder Pen Set Pen Set Pencil 137 Tax 13.23 69.97 12.57 37.78 11.72 9.42 20.96 10.45 31.44 4.46 37.76 31.44 4.04 113.34 12.23 - 17.50 17.91 17.62 40.28 20.99 33.53 6.05 82.83 28.95 91.35 1.40 9.80 35 2 16 28 64 138 139 Sales Rep Jones Kivell Jardine Gill Sorvino Thompson Jones Andrews Jardine Thompson Jones Morgan Howard Parent Jones ce Smith Jones Morgan SA Jones Parent Kivell Smith Parent will Gill Smith Jones Sorvino Jardine Morgan Andrews 179.16 143.97 320.36 159.70 480.54 68.14 577.16 480.54 61.75 1732.53 186.88 267.50 273.75 269.34 615.64 320.84 512.57 92.48 1266.09 442.49 1396.35 21.36 149.73 266.97 76343 140.53 140 141 8.99 17 18 19 20 21 22 23 24 25 26 27 142 15 96 67 143 144 145 146 147 148 74 46 87 4 7 50 51 66 149 28 29 150 30 31 151 152 17.47 49.94 9.19 LA PL Sales Sheet1 + Ready 11 3 100% End Sub Sub Color() Color Macro color a Region Keyboard Shortcut: Ctrl+n Cells.Find Next(After:=ActiveCell). Activate With Selection Interior .Pattern xlSolid .PatternColorIndex xlAutomatic .Color 9670912 TintAndShade 0 .Pattern TintAnd Shade 0 End With End Sub Sub NewTotalExample() = OO AutoSave OFF y Assignment 16.Smith 2 Home Insert Draw Page Layout Formulas Data Review View Developer Acrobat Tell me Share Comments Calibri (Body) :: ' V 11 Insert General ab V v HLV WE 8 DX Delete v Paste BIU FRV A Z Sort & Filter Y $ % ) V 98 99 Conditional Format Cell Formatting as Table Styles E Format v Find & Select Analyze Data Create and Share Adobe PDF W10 B D H K K L M N 0 P Q R S U V W 2 3 4 Order # # 123 124 125 I Total 202.28 1069.47 192.21 5 126 577.51 6 127 7 128 40 129 E Units 95 50 36 27 56 45 60 75 90 32 60 90 29 81 8 9 130 131 132 133 10 11 12 13 14 15 16 134 135 136 OrderDate Region 1/6/15 East 1/23/15 Central 2/9/15 Central 2/26/15 Central 3/15/15 West 3/29/15 West 4/1/15 East 4/18/15 Central 5/5/15 Central 5/22/15 West 6/8/15 East 6/25/15 Central 7/12/15 East 7/29/15 East 8/15/15 East Canto 9/1/15 Central 9/18/15 East 10/5/15 Central 10/22/15 East 11/8/15 East 11/25/15 Central 12/12/15 Central 12/29/15 East 1/15/16 Central 2/1/16 Central 2/18/16 East 3/7/16 West 3/24/16 Central 3/29/16 West 4/10/16 Central Alaska F G UnitCost Ext. Cost 1.99 189.05 19.99 999.5 4.99 179.64 19.99 539.73 2.99 167.44 2.99 134.55 4.99 299.4 1.99 149.25 4.99 449.1 1.99 63.68 8.99 539.4 4.99 449.1 1.99 57.71 19.99 1,619.19 4.99 174.65 125 250 15.99 255.84 8.99 251.72 57536 19.99 299.85 4.99 479.04 1.29 86.43 15.99 1,183.26 8.99 413-54 15 1,305.00 4.99 19.96 19.99 139.93 4.99 249.5 13.99 713 49 1.99 131.34 Item Pencil Binder Pencil Pen Pencil Binder Binder Pencil Pencil Pencil Binder Pencil Binder Binder Pencil Desk Pen Set Binder Pen Pen Pen Set Pencil Pen Set Binder Binder Binder Binder Pen Set Pen Set Pencil 137 Tax 13.23 69.97 12.57 37.78 11.72 9.42 20.96 10.45 31.44 4.46 37.76 31.44 4.04 113.34 12.23 - 17.50 17.91 17.62 40.28 20.99 33.53 6.05 82.83 28.95 91.35 1.40 9.80 35 2 16 28 64 138 139 Sales Rep Jones Kivell Jardine Gill Sorvino Thompson Jones Andrews Jardine Thompson Jones Morgan Howard Parent Jones ce Smith Jones Morgan SA Jones Parent Kivell Smith Parent will Gill Smith Jones Sorvino Jardine Morgan Andrews 179.16 143.97 320.36 159.70 480.54 68.14 577.16 480.54 61.75 1732.53 186.88 267.50 273.75 269.34 615.64 320.84 512.57 92.48 1266.09 442.49 1396.35 21.36 149.73 266.97 76343 140.53 140 141 8.99 17 18 19 20 21 22 23 24 25 26 27 142 15 96 67 143 144 145 146 147 148 74 46 87 4 7 50 51 66 149 28 29 150 30 31 151 152 17.47 49.94 9.19 LA PL Sales Sheet1 + Ready 11 3 100% End Sub Sub Color() Color Macro color a Region Keyboard Shortcut: Ctrl+n Cells.Find Next(After:=ActiveCell). Activate With Selection Interior .Pattern xlSolid .PatternColorIndex xlAutomatic .Color 9670912 TintAndShade 0 .Pattern TintAnd Shade 0 End With End Sub Sub NewTotalExample() =