Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pivot table formatting
Hello,
My pivot table itself is OK, but I would like to have the data sorted by marketshare, so that there is a Ranking with first, second and third place. Furthermore, I would like to have my companies share colored in green, yellow and red, depending on our Marketshare. For the ranking: I do not have any idea how to do this For the coloring: I have tried a conditional formatting, but as soon as I display another view it is gone and I cannot link the formatting by saying: if Col Xy = my company and if Marketshare = Xx then color=red Thank you for your help! Felix |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table formatting in office 2003 | Excel Discussion (Misc queries) | |||
Pivot Table Report formatting - can't select Data Source Order | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) |