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 !