Re: Automatically Conditionally Formatting Pivot Table based on Percentages

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

On Monday, September 12, 2016 at 9:33:54 AM UTC-4, GoTeamGo4321 wrote:
> Hi,
>=20
>      I can't figure out why conditional formatting is not obeying a prett=
y simple set of rules to format percentages based on a scale.  I have adjus=
ted formatting, Pivot Values, and used formulas to format and nothing seems=
to work.  Would appreciate any advice that a guru can provide!
>=20
> 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
>=20
>=20
> Thank you!

Any takers?

Replies

In response to

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