If you include helper cells on sheet 2 which pick up the values from sheet
1, you can then use these sheet 2 cells as inputs to your CF formulae.
--
David Biddulph

"Roy Gudgeon" <Roy wrote in message
...
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