I work with a sheet that is recreated on our server on an ongoing basis. I want to format it (row/column/cell coloring) based on the data in that sheet. What is the best way to accomplish this?

I am a seasoned excel used and also a programmer. I have done limited macro's and vbscripts, but am sure I can figure out the formatting.

I am thinking I should either design a macro/vbscript to update the cells and then copy and paste it into the new workbook each time and run it or if possible, it would be nice to be able to open an existing workbook and have that workbook somehow update the recreated one, or possibly import or copy and paste the data into an existing workbook with the macro/vbscript and then execute it.

Any suggestions would be greatly appreciated.