I?m afraid it ?s not that easy as a simple conditional format. I have about 10 different colors to use and the pivot table changes according to the color selection. I would prefer to do it through VBA but I don?t have the knowledge to do so and that?s why i?m asking the epxerts !