Submit Assignment Forex Colors Project Due Monday by 9:05am Points 100 Submitting a file upload Available Apr 15 at 12am - Apr 29 at 9:05am 14 days Forex Strength Spreadsheet Project It is useful to rank foreign exchange currencies over time to identify market trends between these currencies. One way to help identify those trends is to create a table like the one shown below were a unique color has been placed in every cell for each currency code. This assignment is to create a macro that will perform this task. Duplicate the spreadsheet shown below and construct a macro to place a unique color for each of the eight different currency codes (UPY, AUD, CHF, NZE, EUR, USD, CAD, and GBP) for cells A2 through F9. The Excel spreadsheet is to be named Forex Strength. Two different independent control programs are to be written to accomplish this task. Main Program #1 will use nested FOR statements to select each cell one at a time and Main Program #2 will use nested DO loops. Both Main programs will select each cell one at a time and interrogate that cell to identify the currency code. That Main program will pass control and the currency code to a subroutine named Forexcolors. The Forexcolors subroutine will link a unique color code number to each foreign exchange and pass control that number back to the control program. The control program will then use that number to fill that cell with that unique color. Remember to dimension all variables and place a run button on the spreadsheet. 1 1-yr 1-mo 10-day NZD 9- 16- 13- NZD NZD NZD RUN CAD ICAD rse 5 NZD EUR EUR HF CHF EUR CHF EUR CAD CHF HF CAD 10 Submit Assignment Forex Colors Project Due Monday by 9:05am Points 100 Submitting a file upload Available Apr 15 at 12am - Apr 29 at 9:05am 14 days Forex Strength Spreadsheet Project It is useful to rank foreign exchange currencies over time to identify market trends between these currencies. One way to help identify those trends is to create a table like the one shown below were a unique color has been placed in every cell for each currency code. This assignment is to create a macro that will perform this task. Duplicate the spreadsheet shown below and construct a macro to place a unique color for each of the eight different currency codes (UPY, AUD, CHF, NZE, EUR, USD, CAD, and GBP) for cells A2 through F9. The Excel spreadsheet is to be named Forex Strength. Two different independent control programs are to be written to accomplish this task. Main Program #1 will use nested FOR statements to select each cell one at a time and Main Program #2 will use nested DO loops. Both Main programs will select each cell one at a time and interrogate that cell to identify the currency code. That Main program will pass control and the currency code to a subroutine named Forexcolors. The Forexcolors subroutine will link a unique color code number to each foreign exchange and pass control that number back to the control program. The control program will then use that number to fill that cell with that unique color. Remember to dimension all variables and place a run button on the spreadsheet. 1 1-yr 1-mo 10-day NZD 9- 16- 13- NZD NZD NZD RUN CAD ICAD rse 5 NZD EUR EUR HF CHF EUR CHF EUR CAD CHF HF CAD 10