| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditionally Formatting Cells based on Values in a Range (2007) | Excel Worksheet Functions | |||
| Pivot Table Percentages | Excel Discussion (Misc queries) | |||
| Pivot Table Percentages | Excel Worksheet Functions | |||
| formatting pivot table report (borders automatically showing)... | Excel Programming | |||
| Pivot Table percentages | Excel Discussion (Misc queries) | |||
Linear Mode
