Forum Discussion
Conditional Fomatting in a macro
I can create a manual Conditional formatting rule to do what I want. Rule is that column A includes "Total". and I want all the subtotal lines to be shaded as a break between projects. ...
Attaching a workbook that contains the macro. It's working on my system. I'm on a Mac but that shouldn't matter. Tried to replicate your error but did not succeed. Get all sorts of compile errors but never a "syntax error". Perhaps somebody else can figure it out.
Good luck!
Thanks for the code and for trying. Anyone else have ideas to try?
Or an explanation on why conditional formatting will not record as part of a macro?
Thanks!
Mark