troubleshooting Question

How conditionally format elements of a Pivot Table base their value

Avatar of CG4444
CG4444 asked on
Microsoft Excel
20 Comments1 Solution313 ViewsLast Modified:
Hi there!, I need help with a macro to conditional format a Pivot Table (Pivot1) cells base in their values;
The table (pic1) have columns; Item, SubItem, Item_Child, Code and Qty.
The Pivot(pic2) is a count of Items, the Items can be a Car, Truck, Bike, or Skate. These Items can be “Broken”= NO GO “Good”= GO or “InRepair”= CAUTION.
What I want is to dynamically probably  on the Sheet Change event conditionally format(pic3) if it’s NO GO background color = Red, if its Go green and CAUTION yellow. I need the cells of the Items be these color but not just where the words “GO-NO GO-CAUTION” but the “condition” of Item(GO-NO_GO-CAUTION)  and the “Stage” of the Item(Broken-Good-InRepair).
Can someone please help me with this code?
I really appreciate this help.
Joe Howard

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 20 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 20 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros