This project uses the example Forex Strength spreadsheet posted on Canvas. Macros are to be written to place a unique color for eight different currency codes (JPY, AUD, CHF, NZE, EUR, USD, CAD, and GBP) for cells A2 through F9. Your submission will be graded by placing a different set of Foreign Exchange currencies then found in the example. The Excel spreadsheet is to be named Forex Strength. Activate each macro by a separate RUN button.

Three macros are to be written:

1) The first macro is to be named Forexcolors and will place a unique color for any of the eight foreign exchange currency codes in a preselected cell.

2) The second macro is to be named Control_For is a control macro that sequentially chooses each cell explicitly and then runs the Forexcolors subroutine. For example, Control_For selects cell A2 and then runs the Forexcolors macro. Then selects A3 and then again runs the macro Forexcolors macro and so on. Use nested For statements to select the different cells.

3) The third macro is to be named Control_DO. This control macro accomplishes the same task as described above for the second macro; however, use nested DO LOOP statements to select the different cells.