hi,
I would like to color cells corresponding to labels of row fields in a pivot table
and I would like that they keep it's coloring so that the user can filter to something else and when it comes back to the original filter the cell is colored again.
With some trial I see that this works for cells with numbers, but not with text?
is there any workaround?
anyone tried before?
I guess if it's not possible at user-level, I'll have to keep a hidden table with all the coloring needed and at every pivot table refresh go through the table and color the cells again... any better approach?
Thanks!!
Bookmarks