I have an excel file and I have created Pivot table(sheet12)
using vba code. I have attached the file with the code.
In sheet1,I have my raw data. I need to do one more formatting
in the pivot table. If the Status field in the raw file,
shows 'Short', I have to make the Qty column yellow in the
pivot table as shown on Sheet12.
Experts, please help. Thanks !