Hello friends, hope all is well!
Please look at the attached image. It shows one pivot table results of different branches.
I wish to have a conditional formatting that will highlight the highest value of every set. Ie highlight the highest value of R, T, O, and S.
Thank you very much in advance
Unclear. You only have data in Column C.
Please supply some sample data for group R and specify which should be highlighted.
This could be just group dependant or even row dependant since the years are different - you havent said.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Dear, you are absolutely right!
Please open the Excel attachment, there you will see the pivot table.
I need a conditional formatting to highlight the highest value of all years for each Branch.
i.e. pls. highlight the all-time high value for every branch.
Thanks a lot in advance!
Your results are wrong.
D7 is not the highest for Branch R, it's I9.
For section T its G18.
If you change the number of years (6) you'll have to generate a different pivot table I think.
Therefore this formula will only work for the current pivot table and will need reentering each time.
I don't know a geat deal about piviot tables.
Thinking...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks