Adding VBA Conditional Formatting

[oam]

I had a VBA code that deleted and added conditional formatting rules back to a workbook (attached) that use to work but something happened and now I get an error when the code runs, maybe my excel program is to old.

Is the code I have correct or can you provide help correcting the code so I can update the conditional formatting formulas?


Also, is there a vba code that would allow me to arrange conditional formatting rules in the order I need them in? I have a template worksheet that I copy formats from to another worksheet and after I copy the formats the order of the conditional formatting rules are not in the order I need them to work properly.

Thank you for any and all help with this.