This content has been marked as final. Show 2 replies
I have created an Excel Pivot table based on the helpful tutorials..
My question is:
1. How do I change a range defined for a Pivot table in the source sheet? Looks like It's not possible...
2. I would like to define the font color of the Excel table based on a value of a field in the straight table:
for example: if the value is , then the font should be red. otherwise - black.
Couldn't figure how to do it