Conditional Formatting Pivot Table Data

[ajwooden32]

Below is an image of my pivot table with the rows between columns D-G filled in manually. I should mention this data extends down pass row 100 already, I'm just providing a small sample.

I would like to automate this process as data is added to or removed from this pivot table.

Is there a way to do this with conditional formatting or another way?

Thanks in advance!!!

 

[SanjayGMusafir]

I would like to automate this process as data is added to or removed from this pivot table.

Is there a way to do this with conditional formatting or another way?

What exactly you want to achieve is not clear. Can you explain it better...

 

[ajwooden32]

What exactly you want to achieve is not clear. Can you explain it better...

I want to automatically shade columns D-G like in my example image.

 

[SanjayGMusafir]

To shade alternate rows Select Columns D:G and use following function(s) Conditional Format

Odd Rows

=ISODD(ROW($D1))

Even Rows

=ISEVEN(ROW($D1))

But my thought is Pivot Tables have in-built Formats to do so. Better Try them.

 

[SanjayGMusafir]

To shade alternate rows Select Columns D:G and use following function(s) Conditional Format

Odd Rows

=ISODD(ROW($D1))

Even Rows

=ISEVEN(ROW($D1))

But my thought is Pivot Tables have in-built Formats to do so. Better Try them.

An Add on -

I generally add one more condition while Conditional Format as below -

=And(D1<>"",ISODD(ROW($D1)))

This way it only shades cells with value in it and with entire column(s) under rule, Conditional Format keeps growing with growing rows. No need to re-address rules over and over again.