mark hansen
Well-known Member
- Joined
- Mar 6, 2006
- Messages
- 534
- Office Version
- 2016
- Platform
- Windows
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
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