Automate Production sample input sheet with VBA

I have a worksheet used by eight employees for entering production data on different items. As it is set up now, an item is selected from the drop down list in column F. This illuminates the area to start entering various information about the item as well as triggering spec tolerances found in sheet 2. If a reading is out of spec the cell highlights yellow and red for WAY out of spec. I have accomplished this using conditional formatting to get my desired result but with an undesired side effect. My actual spreadsheet grows very rapidly. Within weeks it can be 3000+ rows. This slows excel down greatly (my current excel file is 1.6 mb) and can occasionally freeze on copy/paste procedures and forget about insert lol. Each 10 row data entry field works independently of the others and as such each has its own independent conditional format operations. Ideally i would like to consolidate this to one operation to cut down on the file size. I am not aware of a way to do it with conditional formatting but i know you can do almost anything with VBA

Any help would be very much appreciated.Test Form.xlsx

Any ideas?