Automatically Conditionally Formatting Pivot Table based on Percentages

Giganews Newsgroups
Subject: Automatically Conditionally Formatting Pivot Table based on Percentages
Posted by:  GoTeamGo4321 (evansit…@gmail.com)
Date: Mon, 12 Sep 2016

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 adjuste=
d formatting, Pivot Values, and used formulas to format and nothing seems t=
o work.  Would appreciate any advice that a guru can provide!

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

Thank you!

Replies