Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables & Conditional Formatting
Can you use conditional formatting within pivot tables? I am trying to
identify balances that exceed certain dollar values or percentages for variance analysis. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables & Conditional Formatting
Sure, just try it any you will see that it CF for Pivot Table data behaves
exactly like CF for non-Pivot-Table-data. Take a look at these links: http://www.contextures.com/xlCondFormat01.html http://www.contextures.com/xlCondFormat03.html http://www.wikihow.com/Apply-Conditi...tting-in-Excel Regards, Ryan--- -- RyGuy "jbird" wrote: Can you use conditional formatting within pivot tables? I am trying to identify balances that exceed certain dollar values or percentages for variance analysis. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables & Conditional Formatting
In Excel 2007, you can apply conditional formatting to sections of the
pivot table and it will move if you chang the pivot table layout. In earlier versions of Excel, you will have to reapply the conditional formatting if you change the layout. It won't automatically adjust. jbird wrote: Can you use conditional formatting within pivot tables? I am trying to identify balances that exceed certain dollar values or percentages for variance analysis. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting in pivot tables based on another column | Excel Discussion (Misc queries) | |||
Excel 2007 - Conditional Formatting applied to Pivot Tables | Excel Discussion (Misc queries) | |||
Conditional Formatting and pivot tables. | Excel Discussion (Misc queries) | |||
Conditional formatting in pivot tables? | Excel Discussion (Misc queries) | |||
Data Tables and Conditional Formatting | Charts and Charting in Excel |