I'm no VBA wiz, quite the contrary, thus my preference for a formulaic approach.
If you copy your Historic sheet and call it Template, then apply the conditional formatting to the Template sheet, you could probably use it in your workflow.
I see in your code the sub
Some of these lines could probably be changed to copy the template sheet instead of creating a new sheet, but the correct syntax momentarily escapes me. Something like
whoever wrote the code for your workbook will probably be able to figure it out much better than I could.
I won't be good for solid VBA advice for a while yet, but maybe this'll give you enough of a start.
hopefully ...
Bookmarks