I am trying to figure out just what it is that you want to color. Now that I see your sample, are you expecting to have 12 sheets, one for each month? And each sheet will have its own color based on the color table you showed, for fonts and borders? So there is no need to dynamically change colors as data is updated, just for initial setup, or if you change the codes?

I see you are using merged cells, which can cause problems later, depending on what you want to do in these cells.