Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default 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?
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,872
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default 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!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditionally Formatting Cells based on Values in a Range (2007) sreid64 Excel Worksheet Functions 3 August 26th 09 08:15 PM
Pivot Table Percentages knowshowrosegrows Excel Discussion (Misc queries) 1 February 28th 08 01:26 AM
Pivot Table Percentages knowshowrosegrows Excel Worksheet Functions 1 February 27th 08 09:36 PM
formatting pivot table report (borders automatically showing)... Perplexed Excel Programming 3 August 12th 06 02:09 AM
Pivot Table percentages cdb Excel Discussion (Misc queries) 2 March 22nd 05 09:09 PM


All times are GMT +1. The time now is 09:53 PM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"