Pivot Tables & Conditional Formatting
in [Functions]
|
Prev: FINDING THE DATE 75 DAYS AFTER A SPECIFIED DATE
Next: Insert Copied Rows or Drag/Drop Formulas While Protected
From: jbird on 3 Jul 2008 14:18 Can you use conditional formatting within pivot tables? I am trying to identify balances that exceed certain dollar values or percentages for variance analysis.
From: ryguy7272 on 4 Jul 2008 00:40 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-Conditional-Formatting-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.
From: Debra Dalgleish on 4 Jul 2008 09:06
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 |