CG4
03-23-2013, 09:34 AM
Hi there!, I need help with a macro to conditional format a Pivot Table 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 dynamically on probably the Sheet change event conditionally format(pic3) if its NO GO background color = Red, if its Go green and CAUTION yellow. I need the cells of the Items be these color not just wherethe 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.
Thanks.
CG4
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 dynamically on probably the Sheet change event conditionally format(pic3) if its NO GO background color = Red, if its Go green and CAUTION yellow. I need the cells of the Items be these color not just wherethe 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.
Thanks.
CG4