An example excel file is included.
1) remove all commas, semicolons, colons via search and replace
2) create a table where I enter in the date (1-1-2013) and the next excel column will adjust according the date input. *There are only 8 cells. So little work.
EXAMPLE - Column A would be (1-1-2013) and naturally Column B would be (1-3-2013) then Column C would be (1-6-2013), etc.
So I enter in ONE DATE and all go according to the first date entered.
3) Those columns that are created after the date is entered fill the cell completely RED
This needs to be able to be applied to ANY excel files with the click of a button. There will be 100's of excel files I am doing this with. This is not for just ONE EXCEL FILE but having the ability to do it over and over again. (If I can copy and paste the code into the excel file...OK) I just need to be able to apply this in mass fairly quickly.