thanks for your reply, but I do not need to show traffic lights, the screenshot is just an example. What I need is to color the row lines of the expressions of the pivot table... As you can see in the screenshot, they are in a light grey, but I need to adjust it to a dark grey according to dimension rows.
Any ideas on this?
I know that, you don't need to show traffic lights, but there similar posts like for your problem.
I think that in this case, the easiest solution is to use tab "Visual Cues" in Chart Properties.
There you can put colours and backgrounds in your tables.
It's useful when you create straight and pivot tables.
In the link which I sent you yesterday, you can see how to fixed you problem.
This is for expression part.
For the dimension part, you can see in the pic, how to change the colour.
You can do this using Custom Format Cell.
See the Attachment.
Took me some time figure it out. PART of the horizontal lines color can be customized use "Custom Format Cell", when "Show Partial Sums" is selected (property->Presentation tab->Dimensions and Expressions).
When you have the "sub total" (default label name "total") in the pivot table, and you MUST right click to open the "Custom Format Cell" when you mouse on the "sub total" row. Then the line color of the horizontal line can be customized, but notice that ONLY the line color of the subtotal row can be changed, NOT the horizontal line color of rows between.