oam
07-05-2022, 05:08 AM
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.
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.