VBA - Apply conditional format to all worksheets

[LALD]

Hi,

I have a large pivot which I have used Show Report Filter Pages on to create a new workbook with multiple sheets with pivots (Approx 80 worksheets). I understand that it is not possible to group sheets and conditionally format them so I am trying to use VBA to do this for me.

I would like code that highlights any cells red in the range D10:D500 that are >159.99 on all sheets. Is this possible? Is it better to conditionally format one sheet and then use a vba to copy the format to all worksheets within the workbook?

Thanks in advance. Really appreciate your help.

 

[Joe4]

Welcome to the Board!

I would recommend using the Macro Recorder, and record yourself applying the Conditional Format to one of the sheets. This will give you the VBA code you need to apply this Conditional Format.

Then, you can put that code in a loop that loops through all the worksheets of your workbook (i.e.: http://www.mrexcel.com/forum/excel-...help-looping-through-all-sheets-workbook.html).

 

[LALD]

Thanks so much. I really appreciate your help. Hopefully in the next release of Excel they will allow you to preserve formatting before you use Show Report Filter Pages.

Thanks again.