Dear all,

I've got a problem with the conditional formating in a pivot table.
My pivot table got two columns "good" and "bad". I want to create a new rule:
each subcolumns of good should automatically be green and each subcolumn of bad should be automatically red.

excelpivotconditionalformating.jpg

I don't know how to create this conditional rule. Can somebody help me?


Thanks in advance