Hi
The Raw data you have will be in different colors / BOLD etc,
when you convert them to pivot is there a way to keep the data in the same color or font ?
Not the calculated value....But the rows & columns ?
Thanks
Mani
Hi
The Raw data you have will be in different colors / BOLD etc,
when you convert them to pivot is there a way to keep the data in the same color or font ?
Not the calculated value....But the rows & columns ?
Thanks
Mani
No, not that I am aware of.when you convert them to pivot is there a way to keep the data in the same color or font ?
How did the original font/color etc get applied?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi
If the original data generated on excel....we can BOLD them, in different font or may be in different color.
when I generate a pivot out of the original data....I want the output in the same font or same color as original data.
sorry, if I was not clear on my post..
Mani
No, your question was clear, perhaps my answer was not.
As with pretty much all formulas, a Pivot Table will bring back data. Formatting - of any kind - is cosmetic, not data, and as such, will not be brought back with formulas and PT's
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks