Pivot Table Conditional Formatting using formula

emmykav

New Member
Joined
Jun 8, 2016
Messages
25
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:

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Canapone

Active Member
Joined
May 10, 2007
Messages
463
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
weeknameValore
2
1​
a
15000​
.
3
1​
b
23377​
abcde
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
 
Last edited:

emmykav

New Member
Joined
Jun 8, 2016
Messages
25
This is a massive help! Thank you. I don't know why I always over complicate things.
 

emmykav

New Member
Joined
Jun 8, 2016
Messages
25
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,130,169
Messages
5,640,550
Members
417,151
Latest member
ChickenTenderer

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top