Formatting the colours of rows of a pivot table|General Excel Questions & Answers|Excel Forum|My Online Training Hub

I'm trying to make a pivot table more readable, but introducing varying colours to the rows. Ideally I'd like to make the row colour to be dependent on a row label such as Date. Failing that, I'd just like to make the rows of the pivot table to be repeating on alternate lines. 

I tried using the 'row banding' option, but nothing changed. I looked for solutions and it was suggested that I clear existing formatting with lthe 'no fill' option. I did that but it hasn't changed the row colours.

I thought I may be able to 'pull though' the formatting from the source table, so I formatted that. But no joy.

Any ideas?