Week | a | b | c | d | e |
1 | 15000 | 23377 | 17750 | 14564 | 14073 |
2 | 18000 | 23377 | 17750 | 14563 | 14074 |
3 | 23000 | 30008 | 20977 | 23999 | 14145 |
4 | 15000 | 23377 | 17750 | 14564 | 14074 |
5 | 21000 | 23377 | 17750 | 14564 | 14074 |
6 | 22000 | 32742 | 19428 | 18641 | 15835 |
7 | 25000 | 32742 | 19428 | 18641 | 15835 |
8 | 24000 | 32741 | 19428 | 18642 | 15836 |
9 | 22000 | 31642 | 20899 | 19837 | 15878 |
10 | 17000 | 41168 | 21920 | 22082 | 16581 |
<tbody>
</tbody>
Please can somebody help me? I have a pivot table, see example above and need use conditional formatting to show when the difference between weeks is <=-2000 go green or >2000 go red, so for example a2 would be red, and a4 would be green. Does anybody know? Obviously I need the conditional formatting to work every time I refresh the data too.
Last edited: