Applying conditional formatting to a pivot table

[ekacan]

Could someone help me out with applying a conditional formatting to a pivot table in Excel 2010?
Example:
I would like to highlight the totals for Sales Regions that did not meet their sales quota for a given month.
Sales regions are drilable to show salesman names and their sales for past 12 months. Quata=10 per month

Let me know if I need to provide additional detail. Thanks in advance.

 

[wynn89]

Hi,

it is similar to applying conditional formatting to normal cells

Applying Conditional Formatting to PivotTables

Regards,
Wynn

 

[Trevor G]

Highlight the first row in your pivot then set the Conditions to your needs and colours etc. Immediately once you click OK in the last cell of the highlighted ones a small formatting icon appears click it and then select your option from the list. It will apply it to the rest of the Pivot.