Sunday, 26 October 2014

How to Apply Conditional Formatting to a Pivot Table

Pivot Table Data Conditional Formatting
As we already know that Conditional Formatting is used to Format the Cells based on some Condition applied on Cell Values.
In the We apply Conditional Formatting to a Pivot Table as explained below:
This format will apply to the data section and it keep effecting even data decreases or decreases...........
First select any Cell in the Data section of the Pivot Table for which we want to apply Conditional Format.



Next go to Home > Conditional Formatting > New Rule



Next Select the "Apply Rule to " option , the Condition and Format of Cells as per below :
Since we are applying the Conditional Format to a Pivot Data , we have to Care Fully select the "Apply Rule To" options as shown below :

Method I :
 Apply Rules to " All Cell showing "Sum of Sales" values for "Sales_Period" and "Prod_ID" :

Since we selected the Apply Rules to " All Cell showing "Sum of Sales" values for "Sales_Period" and "Prod_ID" , the Format will apply to the "Sum of Sales" Data > 150 of the Two Column Labels "Sales_Period" and "Prod_ID" as shown below :
Result :



Method II :
"Apply Rule to " option only for Cells that contain "Sum of Sales" :
Suppose if we select "Apply Rule to " option only for Cells that contain "Sum of Sales" as shown below , the result will be effect on Grand Totals also as shown below :

Result :


Conclusion:
Method-I is appropriate for Conditional Formatting on Pivot Tables.


Thanks,
TAMATAM
BI-Analyst

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts