Conditional Formatting in same column with multi criteria

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.


Help appreciated!!

Previous1

Answers

Sign In or Register to comment.