Conditional formatting Excel 2010

[grumant]

Hello
I have searched and searched the web, but can not find an answer to my problems so I hope you can help.

I have pivot with values from 2012 and 2013 and pr weekday in columns and the names in rows. I would like to format the 2013 values if it is lower than 2012.
So if Thursday 2013 is lower than Thursday 2012 the cell can be filled with red, the same if Saturday 2013 is lower than Saturday 2012. Thats my first challenge.

The next is that when I change the filter, so new names appear I want to keep the same formatting as already mentioned.

Anyone who can help me? Thanks in advance

 

[grumant]

[TABLE="width: 1100"]
<tbody>[TR]
[TD]Class
[/TD]
[TD]A
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Week
[/TD]
[TD]30
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sales
[/TD]
[TD][/TD]
[TD]Weekday
[/TD]
[TD]Date
[/TD]
[TD]Year
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Monday
[/TD]
[TD][/TD]
[TD]Tuesday
[/TD]
[TD][/TD]
[TD="colspan: 2"]Wedensday
[/TD]
[TD]Thursday
[/TD]
[TD][/TD]
[TD]Friday
[/TD]
[TD][/TD]
[TD]Saturday
[/TD]
[TD][/TD]
[TD]Sunday
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]23.07.2012
[/TD]
[TD="align: right"]22.07.2013
[/TD]
[TD="align: right"]24.07.2012
[/TD]
[TD="align: right"]23.07.2013
[/TD]
[TD="align: right"]25.07.2012
[/TD]
[TD="align: right"]24.07.2013
[/TD]
[TD="align: right"]26.07.2012
[/TD]
[TD="align: right"]25.07.2013
[/TD]
[TD="align: right"]27.07.2012
[/TD]
[TD="align: right"]26.07.2013
[/TD]
[TD="align: right"]28.07.2012
[/TD]
[TD="align: right"]27.07.2013
[/TD]
[TD="align: right"]29.07.2012
[/TD]
[TD="align: right"]28.07.2013
[/TD]
[/TR]
[TR]
[TD]Classname
[/TD]
[TD][/TD]
[TD="align: right"]2012
[/TD]
[TD="align: right"]2013
[/TD]
[TD="align: right"]2012
[/TD]
[TD="align: right"]2013
[/TD]
[TD="align: right"]2012
[/TD]
[TD="align: right"]2013
[/TD]
[TD="align: right"]2012
[/TD]
[TD="align: right"]2013
[/TD]
[TD="align: right"]2012
[/TD]
[TD="align: right"]2013
[/TD]
[TD="align: right"]2012
[/TD]
[TD="align: right"]2013
[/TD]
[TD="align: right"]2012
[/TD]
[TD="align: right"]2013
[/TD]
[/TR]
[TR]
[TD]Bob
[/TD]
[TD][/TD]
[TD="align: right"]291
[/TD]
[TD="align: right"]284
[/TD]
[TD="align: right"]260
[/TD]
[TD="align: right"]236
[/TD]
[TD="align: right"]260
[/TD]
[TD="align: right"]192
[/TD]
[TD="align: right"]263
[/TD]
[TD="align: right"]289
[/TD]
[TD="align: right"]274
[/TD]
[TD="align: right"]271
[/TD]
[TD="align: right"]245
[/TD]
[TD="align: right"]312
[/TD]
[TD="align: right"]282
[/TD]
[TD="align: right"]262
[/TD]
[/TR]
[TR]
[TD]Tom
[/TD]
[TD][/TD]
[TD="align: right"]480
[/TD]
[TD="align: right"]410
[/TD]
[TD="align: right"]305
[/TD]
[TD="align: right"]242
[/TD]
[TD="align: right"]347
[/TD]
[TD="align: right"]250
[/TD]
[TD="align: right"]384
[/TD]
[TD="align: right"]388
[/TD]
[TD="align: right"]465
[/TD]
[TD="align: right"]449
[/TD]
[TD="align: right"]420
[/TD]
[TD="align: right"]465
[/TD]
[TD="align: right"]504
[/TD]
[TD="align: right"]521
[/TD]
[/TR]
[TR]
[TD]Susan
[/TD]
[TD][/TD]
[TD="align: right"]214
[/TD]
[TD="align: right"]215
[/TD]
[TD="align: right"]201
[/TD]
[TD="align: right"]134
[/TD]
[TD="align: right"]181
[/TD]
[TD="align: right"]113
[/TD]
[TD="align: right"]220
[/TD]
[TD="align: right"]246
[/TD]
[TD="align: right"]229
[/TD]
[TD="align: right"]269
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]260
[/TD]
[TD="align: right"]269
[/TD]
[/TR]
[TR]
[TD]Dylan
[/TD]
[TD][/TD]
[TD="align: right"]471
[/TD]
[TD="align: right"]516
[/TD]
[TD="align: right"]415
[/TD]
[TD="align: right"]418
[/TD]
[TD="align: right"]398
[/TD]
[TD="align: right"]357
[/TD]
[TD="align: right"]368
[/TD]
[TD="align: right"]366
[/TD]
[TD="align: right"]465
[/TD]
[TD="align: right"]477
[/TD]
[TD="align: right"]478
[/TD]
[TD="align: right"]502
[/TD]
[TD="align: right"]480
[/TD]
[TD="align: right"]488
[/TD]
[/TR]
[TR]
[TD]Rob
[/TD]
[TD][/TD]
[TD="align: right"]206
[/TD]
[TD="align: right"]249
[/TD]
[TD="align: right"]210
[/TD]
[TD="align: right"]195
[/TD]
[TD="align: right"]210
[/TD]
[TD="align: right"]214
[/TD]
[TD="align: right"]232
[/TD]
[TD="align: right"]292
[/TD]
[TD="align: right"]229
[/TD]
[TD="align: right"]274
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]258
[/TD]
[TD="align: right"]271
[/TD]
[/TR]
[TR]
[TD]Chris
[/TD]
[TD][/TD]
[TD="align: right"]244
[/TD]
[TD="align: right"]199
[/TD]
[TD="align: right"]180
[/TD]
[TD="align: right"]132
[/TD]
[TD="align: right"]193
[/TD]
[TD="align: right"]105
[/TD]
[TD="align: right"]246
[/TD]
[TD="align: right"]176
[/TD]
[TD="align: right"]266
[/TD]
[TD="align: right"]245
[/TD]
[TD="align: right"]272
[/TD]
[TD="align: right"]229
[/TD]
[TD="align: right"]293
[/TD]
[TD="align: right"]234
[/TD]
[/TR]
[TR]
[TD]Total
[/TD]
[TD][/TD]
[TD="align: right"]1 906
[/TD]
[TD="align: right"]1 873
[/TD]
[TD="align: right"]1 571
[/TD]
[TD="align: right"]1 357
[/TD]
[TD="align: right"]1 589
[/TD]
[TD="align: right"]1 231
[/TD]
[TD="align: right"]1 713
[/TD]
[TD="align: right"]1 757
[/TD]
[TD="align: right"]1 928
[/TD]
[TD="align: right"]1 985
[/TD]
[TD="align: right"]1 415
[/TD]
[TD="align: right"]1 508
[/TD]
[TD="align: right"]2 077
[/TD]
[TD="align: right"]2 045
[/TD]
[/TR]
</tbody>[/TABLE]