I need help setting up an inspection form with a pass/fail result column. I would like to be able to enter the actual dimension after measuring the part then have the pass/fail column turn green for with word "pass" or turn red for with the word "fail". I've included the tolerance used as well on the spreadsheet. Is there anyway this all can work together in a formula?
.
.