How can I color code data in pivot tables? ie. how do I get all .

[Tperras]

I have a pivot table where I want to highlight common data in different
colours ie. highlight all the number 1's in red, all the "active" (vs
"discontinued") in green, etc. I've seen people do it, but I can't figure it
out.

 

[Debra Dalgleish]

You can use conditional formatting to colour the cells. There are
instructions in Excel's help, and here:

http://www.contextures.com/xlCondFormat01.html