What's not working?
An example of what's not working is the OT% column. Currently it is showing 99.47% in red when the formula states IF OT% >= 99.30% THEN "OT's PASS" it should be blue.
I'm assuming each OT%, OD%, XE% and DOL are all measures? What do you want to see? Should all the criteria be met for a Pass or does just one item of part of the calculation need to be met in order for a Pass?
All 4 items are all measures. I try to see if each of item met with they goal, the value will turn "Green", otherwise it will be "Red".