Conditional Formatting in same column with multi criteria
I am trying to think my way through this and can't quite manage it yet.
I have a log that has stages but the criteria is based upon the substrate chosen.
If Hot dip is selected, the temperature spec is 120-160.
If Cold Rolled Steel is selected, the temp spec is 120-175.
I need the conditional formatting in the same cell, different specs but to turn red to alert the operators and managers of an "out of spec" condition.