conditional formatting and pivot tables

**sean1991** · 01-09-2013, 08:44 AM

Hi there, can someone tell me if its possible to conditionally format a pivot table in excel 2010 so even if the pivot table is refreshed it will still be formatted.

**MarvinP** · 01-09-2013, 08:52 AM

Hi sean1973,

Yes it is easy to CF a pivot table and the formatting will appear even after a refresh of the data. Refresh the attached pivot table and see it work.

**sean1991** · 01-09-2013, 09:57 AM

Thanks but I do not see an option to apply the rule to selected cells or sum of value

**MarvinP** · 01-09-2013, 10:08 AM

You simply select the column of data in the pivot table and then click on the home tab and find Conditional Formatting and look at the formula there, or create your own CF formula.

**sean1991** · 01-09-2013, 11:40 AM

When i click on conditional formatting I do not get the option to apply rule to O selected cells, O all cells showing "sum of values" values or O all cells showing "sum of values" value for "row". I only get to select a rule type.