I have a spreadsheet that will be filled in programmatically. I'd like the cells that will be filled in this way to be written in an alternate color. I know that I can do something akin to:
Range("A1").Font.Color = vbRed
However, I don't want to code 90+ lines of color changes. Is there a way...