It isn't clear to me which cells you want changed, from your description and worksheet. But if you're asking whether VBA can change colors and borders, yes, it can.
The fastest way to see how to do that might be to turn on macro recording and change a cell's characteristics manually. Then turn off macro recording and go look at what it wrote for the program. Usually it records with stupid literal-mindedness; to make the program work well you'll want to change parts of the code to change an addressed cell rather than Selection, and so forth. But it at least will tell you what properties are affected.
Once you do that, if you still have questions (and you probably will), come back and ask again. But this time you'll know more about how it works.
