Is it possible to format sheets (visualize an inventory sheet with white row - grey row - white row - grey row) via macros?

I currently have the sheets set up so that people can just type in what they need. However, often people will cut/copy/paste/drag/fill down, etc and it messes up the formatting I have on the sheet.

Is there a way to set the colors & borders via a macro?