Conditional Formating - Pivot Tables -VBA

[BrotherDude]

Hello I am trying to band the rows in a pivot table based on changes in row values in a specific column. Any ideas? I would like the bands to change from white to grey.

Any help is appreciated.

Thanks,

-Jeff

 

[Cosmic Wizard]

Hey, tried looking at this video, I think it should work for your problem, if not sorry about wasting your time.

Conditional formatting - highlight entire row based on a cell value

 

[BrotherDude]

Excel - Shading entire row based on change of value - Stack Overflow

Found a solution here. Now just need to figure out how to get it in VBA