Forms Enhancement Request

Elizabeth Aird

Now that the forms have had a good update, I would love to be able to add a conditional format OR use the one I have entered in another column. SO THAT the entry would show an error, or out of spec condition.

For instance, operator enters the temperature at 115. I have a column in the worksheet that looks at the entry (with index/match) for the low spec and the high spec. it will return the word RED if out of spec (too low/too high). It would be great if when the data is entered this formula would pull through in the form.

Much like getting an error when I don't enter all the correct information on an order form.