Struggle for several hours about pivot table's color setting problem

[gzboy008]

Hi Guys,

Wish you all the best.

Here's comes a big problem to me. Hope anyone can help. Thanks in advance~

1. I can't remove the blank spece from my pivot which leads my pivot color inconsistent,

2. I can't set the line color as pic 2

[vishsaggi]

Try this.

Get to custom format cell.

Then select the cell which has a value like 300 or 200, that cell value. Then change the Before and After borders and see what you get?

[gzboy008]

Hi Vishwarath,

Still doesn't work... It works for a very few times... But thanks still~

Do you have any other solutions?

[vishsaggi · Accepted solution]

Did you see my qvw file attached, there you can see the red lines right? What do you mean works few times? When you come out of Grid mode are they going off?

[gzboy008]

Yes, I can change the line color base on your file. But if I create another new one, I can only change the vertical one.

Still big thanks to all of the answer. I'll let it go.

Thank you~~~