Hello all,
I have a pivot table in which I would like to conditionally format the Total rows. I can use the Fill Color tool to give all Total Rows for a field to a certain color. I double click on the total field and it highlights all Total rows for that field so I just have to do the color fill once and it works for all of them. If the data changes when the chart is refreshed the Total Rows maintain their color even if they move.
Problem is I would like to conditionally format the Total Rows. It works great when I double click the field for that Total Row and do my condition and pick a color. I can pick one row and it will fill in the corresponding Totals for that field down the pivot table. However, if the data changes the conditional formatting does not follow the total row around like it does for the regular Fill Color Totals.
Is it possible to use conditional formatting instead of Fill Color for pivot tables?
Bookmarks