Re: Automatically Conditionally Formatting Pivot Table based on Percentages

Giganews Newsgroups
Subject: Re: Automatically Conditionally Formatting Pivot Table based on Percentages
Posted by:  Claus Busch (claus_bus…@t-online.de)
Date: Mon, 12 Sep 2016

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?resid=9378aab6121822a3!326&authkey=!AApmk7UTBA7IuAM&ithint=folder%2cxlsm
for "CF"
The order of the rules is important.

Regards
Claus B.

--
Windows10
Office 2016

Replies

None

In response to

Re: Automatically Conditionally Formatting Pivot Table based on Percentages posted by GoTeamGo4321 on Mon, 12 Sep 2016