Conditional formatting: varying criteria

Hi, I have a test result spreadsheet I'm trying to format. The main table is on Spreadsheet 1. Each row is a different test, the columns are the test dates. Most tests have a different minimum an...