Formatting a pivot table

[pdalal]

Attached is a sample spreadsheet which has afield called % of business.
This is going to be used in a Pivot table.
I want that if the "Type other" is "PL" and the % of business went up from 2014 then highlight green if it went down then highlight red.

Thoughts??

[soberguy]

Why not use conditional formatting? Why turn to VBA?

[pdalal]

The reason why I am using vba is because I have the whole pivot table being created from scratch in vba and then sending it as an email attachment.
I would prefer not to add a manual step in between.