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 red, but to stay red until the below cell drops below a difference of £3000. So for example a2:a3 & a5:a9 would turn red. Does anybody know? Obviously I need the conditional formatting to work every time I refresh the data too.