Hi...how do I add the following conditional formatting to this Opportunity for Improvement (OFI) Tracker.
1. Row changes to 'red' if variance (column K) is below the tool cost
2. Row changes to 'yellow' if variance (column K) is below 25% of tool cost
3. Row changes to 'green' if variance (column K) is above 25% of the tool cost
I'm looking to see if we need to rework/repair a tool, are we still making money based on how much we charged the customer. Hope I explained this correctly.