Changing colors of columns in pivot table excel

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3157889%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EChanging%20colors%20of%20columns%20in%20pivot%20table%20excel%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3157889%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHi!%20I%20am%20working%20in%20a%20pivot%20table%20and%20need%20to%20change%20color%20columns%20individually%20to%20separate%20normalized%20composite%20metrics.%20I%20don't%20see%20the%20option%20in%20the%20design%20menu%20to%20go%20beyond%203%20columns%20with%20new%20colors.%20Any%20suggestions%3F%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3157889%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Visitor

Hi! I am working in a pivot table and need to change color columns individually to separate normalized composite metrics. I don't see the option in the design menu to go beyond 3 columns with new colors. Any suggestions?

 

1 Reply
Hai, Try Conditional formatting and add conditions it will help