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.