I have a couple of questions:
- How do you add a columns to a pivot table? I found it the other day and I can't find it again.
- Within that Pivot table I have a Column name R_Stat that shows G, R, A, H, NS. I want to highlight G with the color Green, R with the color Red, A with the color Amber, and H and NS to stay white.
I was thinking of adding another column and placing a conditional if statement with the colors on a seperate worksheet. Is there a way to highlight them within VBA? I am a beginner of VBA for Excel so bare with me.