Conditionally Format Pivot Table cells color base on value (text)

[CG4]

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

[CG4]

Can someone tell me how to move this thread to the Excel Forum, posted in the wrong Forum. Thanks!

[CG4]

Moderator can you delete this thread? was posted in wrong Forum. Thanks!