Pivot Table Conditional Formatting using formula

[emmykav]

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.

 

[Canapone]

Hi

please give a look at conditional formatting rules in this example =A2-A3<=-2000 and A2-A3>2000


https://dl.dropboxusercontent.com/u/106022761/pivotconditionaformatting.xlsx


Excel 2010 32 bit

	A​	B​	C​	D​	E​	F​	G​	H​	I​	J​	K​	L​
1​	week	name	Valore
2​	1​	a	15000​			.
3​	1​	b	23377​				a	b	c	d	e
4​	1​	c	17750​			1	15000​	23377​	17750​	14564​	14073​
5​	1​	d	14564​			2	18000​	23377​	17750​	14563​	14074​
6​	1​	e	14073​			3	23000​	30008​	20977​	23999​	14145​
7​	2​	a	18000​			4	15000​	23377​	17750​	14564​	14074​
8​	2​	b	23377​			5	21000​	23377​	17750​	14564​	14074​
9​	2​	c	17750​			6	22000​	32742​	19428​	18641​	15835​
10​	2​	d	14563​			7	25000​	32742​	19428​	18641​	15835​
11​	2​	e	14074​			8	24000​	32741​	19428​	18642​	15836​
12​	3​	a	23000​			9	22000​	31642​	20899​	19837​	15878​
13​	3​	b	30008​			10	17000​	41168​	21920​	22082​	16581​
14​	3​	c	20977​
15​	3​	d	23999​
16​	3​	e	14145​

<tbody>
</tbody>

Hope it helps

 

[emmykav]

This is a massive help! Thank you. I don't know why I always over complicate things.

 

[emmykav]

out of interest, if I had another pivot table, do you now how I would band the large increases, so that if there's a large chunk of increase it turns red, so for example, the numbers were:

14000
18000
22000
24000
22000
16000

It would turn these numbers

18000
22000
24000
22000

red

Thanks!

 

[Canapone]

Hi


you're welcome.

Thanks for sharing feedback.