Conditional formatting at pivot table for rangking

[henrywinata]

Hi Chandoo,


How are you, I learn a lot from your website.

Anyway, I want to add icon arrows from conditional formatting at pivot table.

As you can see below, I want to give increase arrow if Net Sales bigger than NS Last Month, and also for NS last month versus NS last 3 month and so on.


<img src="http://i47.tinypic.com/14uzxp5.jpg" border="0" alt="Image and video hosting by TinyPic">


Thank You

Henry

 

[bobhc]

good morning henrywinta this link came up from the search box top right.

http://chandoo.org/forums/topic/conditional-formatting-for-pivot-table

 

[henrywinata]

Hi Bobhc,


Thanks for your replying, I think that answer is not am looking for.


For example, Top 10 rank product best seller

Product | This Week | Last Week | Last Month

A 1 1 2

B 2 3 5

C 3 2 1


and the report is pivot table.

I want to add icon (conditional formating)increase/decrease for this week vs last week, last week vs last month.


so, as a visual, I know which one product increasing or decreasing just looking the icon.


I've already tried using the conditional formating and using fomulas if this week larger than last week will be increase and icon up (green) show up. But nothing happen, I guess I am missing something.


Can you help me ?


Thanks

Henry

 

[bobhc]

Henrywinata, do you mean some thing like the upload

https://dl.dropbox.com/u/34893656/henrywinata.xlsx