Automatically Conditionally Formatting Pivot Table based on Percentages
 

Hi,

I can't figure out why conditional formatting is not obeying a pretty simple set of rules to format percentages based on a scale. I have adjusted formatting, Pivot Values, and used formulas to format and nothing seems to work. Would appreciate any advice that a guru can provide!

2996 3027 101.0%
2520 2520 100.0%
340 340 100.0%
8470 8470 100.0%
3747 3925 104.8% Should format anything =103% as Red "Stop"
1288 1300 100.9% Anything between 100.1% and 103% as Yellow
153 153 100.0% Anything <= 100% as Green
2339 2438 104.2%
675 675 100.0%
10535 10543 100.1%
3797 3880 102.2%
48 48 100.0%


Thank you!

Automatically Conditionally Formatting Pivot Table based on Percentages
 

On Monday, September 12, 2016 at 9:33:54 AM UTC-4, GoTeamGo4321 wrote:
Hi,

I can't figure out why conditional formatting is not obeying a pretty simple set of rules to format percentages based on a scale. I have adjusted formatting, Pivot Values, and used formulas to format and nothing seems to work. Would appreciate any advice that a guru can provide!

2996 3027 101.0%
2520 2520 100.0%
340 340 100.0%
8470 8470 100.0%
3747 3925 104.8% Should format anything =103% as Red "Stop"
1288 1300 100.9% Anything between 100.1% and 103% as Yellow
153 153 100.0% Anything <= 100% as Green
2339 2438 104.2%
675 675 100.0%
10535 10543 100.1%
3797 3880 102.2%
48 48 100.0%


Thank you!



Any takers?

Automatically Conditionally Formatting Pivot Table based on Percentages
 

Hi,

Am Mon, 12 Sep 2016 11:15:36 -0700 (PDT) schrieb GoTeamGo4321:

On Monday, September 12, 2016 at 9:33:54 AM UTC-4, GoTeamGo4321 wrote:
I can't figure out why conditional formatting is not obeying a pretty simple set of rules to format percentages based on a scale. I have adjusted formatting, Pivot Values, and used formulas to format and nothing seems to work. Would appreciate any advice that a guru can provide!

2996 3027 101.0%
2520 2520 100.0%
340 340 100.0%
8470 8470 100.0%
3747 3925 104.8% Should format anything =103% as Red "Stop"
1288 1300 100.9% Anything between 100.1% and 103% as Yellow
153 153 100.0% Anything <= 100% as Green
2339 2438 104.2%
675 675 100.0%
10535 10543 100.1%
3797 3880 102.2%
48 48 100.0%

have a look:
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for "CF"
The order of the rules is important.


Regards
Claus B.
--
Windows10
Office 2016

Automatically Conditionally Formatting Pivot Table based on Percentages
 

On Monday, September 12, 2016 at 2:39:35 PM UTC-4, Claus Busch wrote:
Hi,

Am Mon, 12 Sep 2016 11:15:36 -0700 (PDT) schrieb GoTeamGo4321:

On Monday, September 12, 2016 at 9:33:54 AM UTC-4, GoTeamGo4321 wrote:
I can't figure out why conditional formatting is not obeying a pretty simple set of rules to format percentages based on a scale. I have adjusted formatting, Pivot Values, and used formulas to format and nothing seems to work. Would appreciate any advice that a guru can provide!

2996 3027 101.0%
2520 2520 100.0%
340 340 100.0%
8470 8470 100.0%
3747 3925 104.8% Should format anything =103% as Red "Stop"
1288 1300 100.9% Anything between 100.1% and 103% as Yellow
153 153 100.0% Anything <= 100% as Green
2339 2438 104.2%
675 675 100.0%
10535 10543 100.1%
3797 3880 102.2%
48 48 100.0%

have a look:
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for "CF"
The order of the rules is important.


Regards
Claus B.
--
Windows10
Office 2016

Claus - you're 2/2 for me! Thank you!