Hi Guys

I am trying to condtionally format cells in sheet 2 using values (stopwatch
times) listed in sheet one. However I get an error message telling me "I
cannot reference other worksheets or workbooks for conditional format
criteria"

Any way round this else otehrwise it means creating each rule individually