conditional formatting in pivot table

**sach0025** · 02-01-2007, 12:26 PM

Can anyone please tell me if it is possible to have conditional formatting in pivot table? For example. My data contains three columns. I want items greater than x number to be highligted in a different color. I know I can do this in the spreadsheet but how can I view this in the reflecting Pivot table. Even if I refresh the pivot table, it does not show up. I would really appreciate any help on this !! I am using Excel 2003 Thanks much !

**Carim** · 02-01-2007, 12:35 PM

Hi,

Since a pivot table is an object on its own, you need to select the range of cells the table might use and add your conditional formatting formula ...

**sach0025** · 02-01-2007, 12:41 PM

Thank you for your reply!. Can you please elaborate on this! I formatted the cells where the pivot table is retreiving its data from - but it does not show up in the table itself. Thank you so much! I am super stuck right now.

Ritu

**Carim** · 02-01-2007, 12:44 PM

Sorry for not expressing myself clearly enough ...
Conditional Formatting has to applied at the destination (not the source) ...

**sach0025** · 02-01-2007, 12:48 PM

But the destination (pivot table) - only provides 'Format Cells' option but nothing at all for 'Conditional Formatting'. Thanks Again !

**Carim** · 02-01-2007, 12:55 PM

Hi again...

Within the pivot Table, in the data area, highlight the area in which you want to apply formatting ... and use Excel Main Menu Format Conditional Formatting ...