Forum Discussion

Mark97348's avatar
Mark97348
Copper Contributor
Oct 01, 2019

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.   ...
Conditional Formatting
excel
Macros
Mark97348's avatar
Mark97348
Copper Contributor
Oct 01, 2019

Riny_van_Eekelen 

 

Thanks very much for the response.  I found the stack overflow code in a couple of my google searches yesterday as well. But I kept getting errors

 

I tried the code you posted.  I am getting a "Compile error:  Syntax error"

 

I will tinker with it a bit more to see if I can find a working syntax.  Just not sure what Visual Basic doesn't like about the syntax...  I have seen very similar code posted and others online indicate it will work.

 

I am still missing something.

 

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Oct 02, 2019

Mark97348 

 

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!

  • Mark97348's avatar
    Mark97348
    Copper Contributor
    Oct 02, 2019

    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

Resources