Apply Conditional formatting to all columns in a Pivot table

[mark hansen]

I having a hard time applying conditional formatting to all columns in a pivot table.

I've done some searches and discovered the option box at the top of the conditional format edit box (when using a pivot table) with the three options that solves the problem for one column. When new rows are added to the pivot table, I can get the conditional formatting extend to the new rows. That's good. But selecting those options (the bottom one) only selects one column header and applies the formatting to only that one column... Not all the columns.

I started to create a different conditional formatting rule for each column, but I'm thinking there must be a better way. One pivot table has 10 data columns and another has 20 data columns. Do I really need to apply one conditional formatting rule for each column? I shutter to think if I need to change formatting parameters and I need to do that on 10 or 20 individual rules.

Am I overlooking something?

Thanks,
Mark

 

[pjmorris]

I would suggest you're being too specific in your selection in the New CF dialogue box. For example, this choice will apply the formatting to all cells in the values area. The trick is to try different options in the dialogue until you get the result you want. - You shouldn't be applying it to each column.

HTH

 

[mark hansen]

Thanks for the reply. I'll give that a try.