Conditional formatting in a pivot table

[naylorpsu]

Good morning, everyone.

I have a pivot table that I would like to add some conditional formatting to and I am not sure how to accomplish this. I have monthly sales average for System 1 and System 2. If there is an increase with System 2 compared to System 1, I would like to show cell filled in one color. If not, I would like to show that cell filled in a different color.

Also, I do not know if there is a way to add another column to the end to show the percent increase? If so, how could that be done?

[TABLE="class: grid, width: 856"]
<colgroup><col><col><col><col span="4"></colgroup><tbody>[TR]
[TD] [/TD]
[TD]System 1[/TD]
[TD] [/TD]
[TD][/TD]
[TD]System 2[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Months On System[/TD]
[TD]Sales Total[/TD]
[TD]Avg Monthly Sales[/TD]
[TD]Months On System[/TD]
[TD]Sales Total[/TD]
[TD]Avg Monthly Sales[/TD]
[/TR]
[TR]
[TD]68388[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]$261,181[/TD]
[TD="align: right"]$21,765[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]$85,665[/TD]
[TD="align: right"]$28,555[/TD]
[/TR]
[TR]
[TD]68389[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]$248,272[/TD]
[TD="align: right"]$22,570[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]$103,642[/TD]
[TD="align: right"]$25,910[/TD]
[/TR]
[TR]
[TD]68392[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]$202,415[/TD]
[TD="align: right"]$18,401[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]$60,756[/TD]
[TD="align: right"]$20,252[/TD]
[/TR]
[TR]
[TD]68400[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]$179,242[/TD]
[TD="align: right"]$16,295[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]$60,460[/TD]
[TD="align: right"]$15,115[/TD]
[/TR]
[TR]
[TD]68383[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]$237,092[/TD]
[TD="align: right"]$21,554[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]$95,311[/TD]
[TD="align: right"]$23,828[/TD]
[/TR]
</tbody>[/TABLE]


Thank you in advance.