[SOLVED] Fill Cells based on Color of Other Cells in Two Columns

Hello everyone.

Please see attached.

In the Initial tab, I would like a macro that fills all blanks from A2 to the last cell in col A where adjacent cell is populated, with a label based on the cell color in either col D or col E. The labels will be: Payment if the cell color is Red (color index 3) , Deposit if the cell color is Yellow (color index 6), and Fee if the cell color is Green (color index 43) .

The desired result is in the Desired Result tab.

Would really appreciate any assistance on this.